/*
 Navicat Premium Data Transfer

 Source Server         : ipc
 Source Server Type    : MySQL
 Source Server Version : 50520
 Source Host           : localhost
 Source Database       : rm

 Target Server Type    : MySQL
 Target Server Version : 50520
 File Encoding         : utf-8

 Date: 12/31/2013 12:10:10 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `a_item`
-- ----------------------------
DROP TABLE IF EXISTS `a_item`;
CREATE TABLE `a_item` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `oid` int(10) DEFAULT NULL,
  `mid` int(10) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `price` float DEFAULT NULL,
  `dt_complete` datetime DEFAULT NULL,
  `score_menu` int(10) DEFAULT NULL,
  `score_server` int(10) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `a_order`
-- ----------------------------
DROP TABLE IF EXISTS `a_order`;
CREATE TABLE `a_order` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `seat` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `wid` int(10) DEFAULT NULL,
  `cid` int(10) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `dt_complete` datetime DEFAULT NULL,
  `dt_check` int(10) DEFAULT NULL,
  `score_menu` int(10) DEFAULT NULL,
  `score_server` int(10) DEFAULT NULL,
  `score_remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `l_alarm`
-- ----------------------------
DROP TABLE IF EXISTS `l_alarm`;
CREATE TABLE `l_alarm` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '报警记录ID',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL COMMENT '建立时间',
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL COMMENT '状态类名',
  `oid` int(11) DEFAULT NULL COMMENT '对象ID（stdid eid）',
  `prop_name` varchar(255) DEFAULT NULL COMMENT '属性名',
  `prop_val` varchar(255) DEFAULT NULL COMMENT '属性值',
  `level` varchar(50) DEFAULT NULL COMMENT '报警级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='报警日志记录表';

-- ----------------------------
--  Records of `l_alarm`
-- ----------------------------
BEGIN;
INSERT INTO `l_alarm` VALUES ('1', null, '2012-02-16 00:00:00', null, '设备【1】温度报警', null, null, '1', 'Temperature', '44', '2'), ('2', null, '2012-02-22 00:00:00', null, '设备【2】温度报警', null, null, '2', 'Temperature', '32', '2'), ('3', null, '2012-02-05 00:00:00', null, '设备【3】温度报警', null, null, '3', 'Temperature', '47', '2');
COMMIT;

-- ----------------------------
--  Table structure for `l_sync`
-- ----------------------------
DROP TABLE IF EXISTS `l_sync`;
CREATE TABLE `l_sync` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `entity` varchar(128) DEFAULT NULL,
  `entity_id` int(10) DEFAULT NULL,
  `oper` int(10) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `snap_json` varchar(4096) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `l_sync`
-- ----------------------------
BEGIN;
INSERT INTO `l_sync` VALUES ('1', '1', 'dao.hb.ODevice', '2', '85', '2013-12-17 10:50:55', null, null), ('2', '1', 'dao.hb.ODevice', '2', '85', '2013-12-17 11:01:30', null, 'id:[2] [2] ipAddr:[127.0.0.1666] [127.0.0.1666kkkk] '), ('3', '1', 'dao.hb.ODevice', '3', '85', '2013-12-17 11:03:42', null, 'ipAddr:[127.0.0.1] [127.0.0.1yyy] '), ('4', '1', 'dao.hb.OAttachment', '4', '82', '2013-12-17 11:37:20', null, null), ('5', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 12:02:56', null, 'avatar:[null] / [_[1]1_2013_12_17_2_IMG_0164.PNG]\n '), ('6', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 12:53:54', null, 'avatar:[_[1]1_2013_12_17_2_IMG_0164.PNG] / [_[1]1_2013_12_17_3_IMG_0163.PNG]\n '), ('7', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 13:01:05', null, 'avatar:[_[1]1_2013_12_17_3_IMG_0163.PNG] / [_[1]1_2013_12_17_5_IMG_0166.PNG]\n '), ('8', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 13:57:19', null, 'avatar:[_[1]1_2013_12_17_5_IMG_0166.PNG] / [_[1]1_2013_12_17_6_IMG_0164.PNG]\n '), ('9', '1', 'dao.hb.UUser', '6', '85', '2013-12-17 16:04:54', null, 'avatar:[null] / [_[1]1_2013_12_17_3_IMG_0175.PNG]\n '), ('10', '1', 'dao.hb.UUser', '6', '85', '2013-12-17 16:18:51', null, 'avatar:[_[1]1_2013_12_17_3_IMG_0175.PNG] / [_[1]1_2013_12_17_6_IMG_0163.PNG]\n '), ('11', '1', 'dao.hb.ODevice', '1', '85', '2013-12-17 16:54:07', null, 'remark:[jh\n\n\nertwtetetw] / [jh\n\n\nertwtetetw<div><br></div><div>lkkssss中文</div>]\n '), ('12', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 19:28:07', null, 'avatar:[_[1]1_2013_12_17_6_IMG_0164.PNG] / [1\\avatar.jpg]\n '), ('13', '1', 'dao.hb.UUser', '6', '85', '2013-12-17 19:31:31', null, 'avatar:[_[1]1_2013_12_17_6_IMG_0163.PNG] / [1\\avatar.jpg]\n '), ('14', '1', 'dao.hb.UUser', '6', '85', '2013-12-17 19:50:10', null, 'avatar:[1\\avatar.jpg] / [6\\avatar.jpg]\n '), ('15', '1', 'dao.hb.UUser', '1', '85', '2013-12-17 20:19:54', null, 'avatar:[1\\avatar.jpg] / [1\\avatar.jpg]\n '), ('16', '1', 'dao.hb.ODevice', '36', '65', '2013-12-17 20:44:40', null, null), ('17', '1', 'dao.hb.ODevice', '37', '65', '2013-12-17 20:44:54', null, null), ('18', '1', 'dao.hb.ODevice', '38', '65', '2013-12-17 20:45:24', null, null), ('19', '1', 'dao.hb.ODevice', '39', '65', '2013-12-17 20:45:59', null, null), ('20', '1', 'dao.hb.ODevice', '39', '82', '2013-12-17 22:12:42', null, null), ('21', '1', 'dao.hb.PTask', '1', '65', '2013-12-18 12:58:19', null, null), ('22', '1', 'dao.hb.PTask', '1', '85', '2013-12-18 12:59:14', null, 'summery:[null] / [wsqss]\n '), ('23', '1', 'dao.hb.PTask', '1', '85', '2013-12-18 12:59:37', null, 'stype:[null] / [www]\n '), ('24', '1', 'dao.hb.PProject', '1', '65', '2013-12-18 13:10:11', null, null), ('25', '1', 'dao.hb.PTask', '1', '85', '2013-12-18 13:19:44', null, 'stype:[www] / [测试bug]\n '), ('26', '1', 'dao.hb.PTask', '1', '85', '2013-12-18 13:24:58', null, 'priority:[null] / [Critical]\n '), ('27', '1', 'dao.hb.PProject', '1', '85', '2013-12-18 13:30:19', null, 'name:[null] / [项目一]\n keyname:[null] / [PJ1]\n '), ('28', '1', 'dao.hb.PTask', '2', '65', '2013-12-18 13:30:26', null, null), ('29', '1', 'dao.hb.OAttachment', '16', '65', '2013-12-18 13:30:33', null, null), ('30', '1', 'dao.hb.OAttachment', '17', '65', '2013-12-18 13:31:29', null, null), ('31', '1', 'dao.hb.PTask', '3', '65', '2013-12-18 13:44:04', null, null), ('32', '1', 'dao.hb.PTask', '4', '65', '2013-12-18 13:44:43', null, null), ('34', '1', 'dao.hb.RRel', '2', '65', '2013-12-18 17:38:46', null, null), ('35', '1', 'dao.hb.RRel', '3', '65', '2013-12-18 17:41:19', null, null), ('36', '1', 'dao.hb.RRel', '2', '82', '2013-12-18 19:05:30', null, null), ('37', '1', 'dao.hb.RRel', '3', '82', '2013-12-18 19:05:30', null, null), ('38', '1', 'dao.hb.RRel', '4', '65', '2013-12-18 19:05:43', null, null), ('39', '1', 'dao.hb.RRel', '5', '65', '2013-12-18 19:32:46', null, null), ('40', '1', 'dao.hb.PTask', '5', '65', '2013-12-18 19:55:18', null, null), ('41', '1', 'dao.hb.PTask', '2', '85', '2013-12-18 19:55:50', null, 'name:[null] / [任务2]\n '), ('42', '1', 'dao.hb.PTask', '5', '85', '2013-12-18 19:56:00', null, 'name:[null] / [任务5]\n '), ('43', '1', 'dao.hb.RRel', '6', '65', '2013-12-18 20:09:07', null, null), ('44', '1', 'dao.hb.PTask', '4', '85', '2013-12-18 20:09:41', null, 'aid:[null] / [8]\n '), ('45', '1', 'dao.hb.PTask', '3', '85', '2013-12-18 20:09:59', null, 'tid:[null] / []\n aid:[null] / [6]\n '), ('46', '1', 'dao.hb.PTask', '4', '85', '2013-12-18 20:31:50', null, 'aid:[8] / [1]\n '), ('47', '1', 'dao.hb.PTask', '5', '85', '2013-12-18 20:32:13', null, 'tid:[null] / []\n aid:[null] / [6]\n '), ('48', '1', 'dao.hb.PProject', '1', '85', '2013-12-18 21:13:59', null, 'stype:[null] / [jj]\n '), ('49', '1', 'dao.hb.PTask', '3', '85', '2013-12-18 22:11:31', null, 'aid:[6] / [8]\n '), ('50', '1', 'dao.hb.PTask', '3', '85', '2013-12-18 22:21:19', null, 'stype:[null] / [测试bug]\n '), ('51', '1', 'dao.hb.RRel', '5', '82', '2013-12-19 08:34:55', null, null), ('52', '1', 'dao.hb.RRel', '7', '65', '2013-12-19 08:52:49', null, null), ('53', '1', 'dao.hb.UUser', '1', '85', '2013-12-19 08:57:49', null, 'avatar:[1\\avatar.jpg] / [1\\avatar.jpg]\n '), ('54', '1', 'dao.hb.ODevice', '2', '85', '2013-12-19 09:08:55', null, 'status:[0] / [1]\n '), ('55', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 09:13:44', null, 'aid:[null] / [6]\n '), ('56', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 10:10:00', null, 'aid:[6] / [1]\n '), ('57', '1', 'dao.hb.PTask', '1', '85', '2013-12-19 10:11:08', null, 'aid:[null] / [8]\n '), ('58', '1', 'dao.hb.PTask', '6', '65', '2013-12-19 10:18:20', null, null), ('59', '1', 'dao.hb.PTask', '6', '85', '2013-12-19 10:18:27', null, 'aid:[null] / [8]\n '), ('60', '1', 'dao.hb.PProject', '2', '65', '2013-12-19 10:20:16', null, null), ('61', '1', 'dao.hb.RRel', '8', '65', '2013-12-19 10:20:36', null, null), ('62', '1', 'dao.hb.RRel', '9', '65', '2013-12-19 10:20:36', null, null), ('63', '1', 'dao.hb.RRel', '10', '65', '2013-12-19 10:21:51', null, null), ('64', '1', 'dao.hb.RRel', '11', '65', '2013-12-19 10:21:51', null, null), ('65', '1', 'dao.hb.PTask', '7', '65', '2013-12-19 10:22:12', null, null), ('66', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 10:23:17', null, 'name:[null] / [task7]\n '), ('67', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:14:57', null, 'aid:[null] / [9]\n '), ('68', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:17:17', null, 'aid:[9] / [8]\n '), ('69', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:20:34', null, 'aid:[8] / [9]\n '), ('70', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:23:44', null, 'aid:[9] / [8]\n '), ('71', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 11:23:59', null, 'aid:[1] / [6]\n '), ('72', '1', 'dao.hb.PTask', '1', '85', '2013-12-19 11:24:47', null, 'aid:[8] / [9]\n '), ('73', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 11:27:45', null, 'aid:[6] / [1]\n '), ('74', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:27:57', null, 'aid:[8] / [9]\n '), ('75', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 11:29:14', null, 'aid:[1] / [6]\n '), ('76', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 11:29:23', null, 'aid:[9] / [8]\n '), ('77', '1', 'dao.hb.PTask', '2', '85', '2013-12-19 11:52:53', null, 'aid:[6] / [1]\n '), ('78', '1', 'dao.hb.PTask', '8', '65', '2013-12-19 12:06:27', null, null), ('79', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 12:15:13', null, 'stype:[jj] / [外派]\n '), ('80', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 12:35:06', null, 'stype:[null] / [合同]\n '), ('81', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 12:35:16', null, 'status:[null] / [需求调研]\n '), ('82', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 12:35:24', null, 'status:[null] / [部署]\n '), ('83', '1', 'dao.hb.PTask', '4', '85', '2013-12-19 12:59:06', null, 'pid:[null] / []\n stype:[null] / [测试bug]\n name:[null] / []\n '), ('84', '1', 'dao.hb.PTask', '7', '85', '2013-12-19 13:42:28', null, 'priority:[null] / [Critical]\n resolved:[null] / [部分修改]\n '), ('85', '1', 'dao.hb.PTask', '6', '85', '2013-12-19 13:44:38', null, 'stype:[null] / [新功能]\n name:[null] / [建议111]\n priority:[null] / [Critical]\n resolved:[null] / [测试未完成]\n '), ('86', '1', 'dao.hb.PTask', '6', '85', '2013-12-19 13:49:15', null, 'status:[null] / [处理中]\n '), ('87', '1', 'dao.hb.UUser', '9', '85', '2013-12-19 16:20:23', null, 'userId:[tester_1] / [tester_1999]\n '), ('88', '1', 'dao.hb.UUser', '1', '85', '2013-12-19 16:20:47', null, 'userId:[sys] / [sys888]\n '), ('89', '1', 'dao.hb.UUser', '1', '85', '2013-12-19 16:21:48', null, 'userId:[sys888] / [sys]\n name:[sysroot] / [sysroot8777]\n '), ('90', '1', 'dao.hb.UUser', '8', '85', '2013-12-19 16:30:46', null, 'remark:[null] / [ddd]\n '), ('91', '1', 'dao.hb.UUser', '1', '85', '2013-12-19 16:30:57', null, 'name:[sysroot8777] / [sysroot]\n '), ('92', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:20:42', null, 'stype:[外派] / [预研]\n '), ('93', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:24:48', null, 'stype:[预研] / [合同]\n '), ('94', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:34:40', null, ''), ('95', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 20:36:37', null, ''), ('96', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:39:32', null, ''), ('97', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 20:43:58', null, ''), ('98', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:46:22', null, ''), ('99', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:48:05', null, 'dtCreate:[2013-12-18 13:10:11.0] / [Wed Dec 18 13:10:11 CST 2013]\n dtModify:[2013-12-18 13:10:11.0] / [Thu Dec 19 20:47:44 CST 2013]\n '), ('100', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:48:54', null, 'dtModify:[2013-12-19 20:47:44.0] / [Thu Dec 19 20:48:45 CST 2013]\n '), ('101', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 20:51:05', null, 'dtCreate:[2013-12-19 10:20:16.0] / [Thu Dec 19 10:20:16 CST 2013]\n dtModify:[2013-12-19 10:20:16.0] / [Thu Dec 19 20:50:27 CST 2013]\n '), ('102', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 20:54:30', null, 'dtCreate:[2013-12-18 13:10:11.0] / [Sun Dec 01 00:00:00 CST 2013]\n dtModify:[2013-12-19 20:48:45.0] / [Thu Dec 19 20:54:21 CST 2013]\n '), ('103', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:07:58', null, 'dtCreate:[2013-12-01 00:00:00.0] / [Tue Dec 10 00:00:00 CST 2013]\n '), ('104', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:08:41', null, 'dtCreate:[2013-12-10 00:00:00.0] / [Fri Dec 06 00:00:00 CST 2013]\n '), ('105', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:09:01', null, 'dtCreate:[2013-12-06 00:00:00.0] / [Sat Dec 28 00:00:00 CST 2013]\n '), ('106', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:09:45', null, 'name:[项目一] / [项目一1111]\n '), ('107', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:13:26', null, 'name:[项目一1111] / [项目一]\n '), ('108', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:15:06', null, 'name:[项目一] / [项目一122]\n '), ('109', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:25:21', null, 'name:[项目一122] / [项目一1]\n '), ('110', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:26:29', null, 'name:[项目一1] / [项目一122]\n '), ('111', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 21:39:32', null, 'keyname:[PJ1] / [PJ1333]\n '), ('112', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 21:45:30', null, 'name:[项目二] / [项目二889]\n '), ('113', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 21:50:56', null, 'name:[项目二889] / [项目二889y]\n '), ('114', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 22:00:35', null, 'keyname:[PJ1333] / [PJ13335]\n '), ('115', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 22:02:20', null, 'keyname:[PRJ2] / [PRJ23]\n '), ('116', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 22:03:14', null, 'keyname:[PJ13335] / [PJ133357]\n '), ('117', '1', 'dao.hb.PProject', '1', '85', '2013-12-19 22:07:50', null, 'keyname:[PJ133357] / [PJ1333579]\n '), ('118', '1', 'dao.hb.PProject', '2', '85', '2013-12-19 22:08:03', null, 'name:[项目二889y] / [项目二889y7]\n '), ('119', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 16:43:58', null, 'name:[项目一122] / [11]\n '), ('120', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 16:44:14', null, 'name:[11] / [113]\n '), ('121', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 16:44:51', null, 'name:[113] / [11368]\n '), ('122', '1', 'dao.hb.PProject', '2', '85', '2013-12-20 16:54:41', null, 'keyname:[PRJ23] / [PRJ23u]\n '), ('123', '1', 'dao.hb.PProject', '2', '85', '2013-12-20 16:56:41', null, 'keyname:[PRJ23u] / [PRJ23uk]\n '), ('124', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 17:32:01', null, 'name:[11368] / [1136]\n '), ('125', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 17:33:19', null, 'name:[1136] / [113]\n '), ('126', '1', 'dao.hb.PTask', '8', '85', '2013-12-20 17:35:39', null, 'pid:[null] / []\n name:[null] / [su]\n '), ('127', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 19:27:10', null, 'name:[113] / [11345e]\n '), ('128', '1', 'dao.hb.PTask', '7', '85', '2013-12-20 20:48:16', null, 'cid:[null] / [9]\n '), ('129', '1', 'dao.hb.PTask', '8', '85', '2013-12-20 20:53:57', null, 'cid:[null] / [7]\n '), ('130', '1', 'dao.hb.PTask', '8', '85', '2013-12-20 21:07:07', null, 'cid:[7] / [78]\n '), ('131', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 21:17:15', null, 'cid:[null] / [8]\n '), ('132', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 21:23:16', null, 'cid:[8] / [89]\n '), ('133', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 21:24:45', null, 'cid:[89] / [899]\n '), ('134', '1', 'dao.hb.PTask', '2', '85', '2013-12-20 21:24:45', null, 'cid:[null] / [8]\n '), ('135', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 21:54:27', null, 'cid:[899] / [8997]\n '), ('136', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 22:31:40', null, 'cid:[8997] / [89979]\n '), ('137', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 22:35:40', null, 'cid:[89979] / [899799]\n '), ('138', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 22:42:25', null, 'cid:[899799] / [89979]\n '), ('139', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 22:42:45', null, 'cid:[89979] / [8997]\n '), ('140', '1', 'dao.hb.PTask', '1', '85', '2013-12-20 22:43:15', null, 'cid:[8997] / [899]\n '), ('141', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 22:43:29', null, 'name:[11345e] / [11345]\n '), ('142', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 22:43:36', null, 'name:[11345] / [1134]\n '), ('143', '1', 'dao.hb.PProject', '1', '85', '2013-12-20 22:43:45', null, 'aid:[null] / []\n name:[1134] / [113]\n '), ('144', '1', 'dao.hb.PProject', '2', '85', '2013-12-20 22:43:55', null, 'name:[项目二889y7] / [项目二8]\n '), ('145', '1', 'dao.hb.PProject', '2', '85', '2013-12-20 22:44:05', null, 'name:[项目二8] / [项目]\n '), ('146', '1', 'dao.hb.PProject', '1', '85', '2013-12-21 21:36:42', null, 'dtCreate:[2013-12-28 00:00:00.0] / [Mon Dec 09 00:00:00 CST 2013]\n '), ('147', '1', 'dao.hb.PProject', '1', '85', '2013-12-21 21:53:28', null, 'aid:[null] / []\n dtCreate:[2013-12-09 00:00:00.0] / [Tue Dec 03 00:00:00 CST 2013]\n '), ('148', '1', 'dao.hb.PProject', '1', '85', '2013-12-21 21:54:29', null, 'keyname:[PJ1333579] / [PJ13]\n avatar:[null] / []\n '), ('149', '1', 'dao.hb.PProject', '2', '85', '2013-12-21 21:54:29', null, 'avatar:[null] / []\n '), ('150', '1', 'dao.hb.PProject', '2', '85', '2013-12-21 21:54:35', null, 'keyname:[PRJ23uk] / [PRJ23]\n '), ('151', '1', 'dao.hb.PProject', '1', '85', '2013-12-21 22:54:59', null, 'aid:[null] / []\n dtCreate:[2013-12-03 00:00:00.0] / [Mon Dec 02 00:00:00 CST 2013]\n '), ('152', '1', 'dao.hb.PProject', '2', '85', '2013-12-21 23:24:54', null, 'stype:[合同] / [外派]\n '), ('153', '1', 'dao.hb.PTask', '8', '85', '2013-12-21 23:25:15', null, 'aid:[null] / [9]\n '), ('154', '1', 'dao.hb.PTask', '9', '65', '2013-12-21 23:26:01', null, null), ('155', '1', 'dao.hb.PTask', '9', '85', '2013-12-21 23:26:25', null, 'pid:[null] / [1]\n '), ('156', '1', 'dao.hb.PTask', '9', '85', '2013-12-21 23:26:32', null, 'aid:[null] / [1]\n '), ('157', '1', 'dao.hb.PTask', '9', '85', '2013-12-21 23:27:52', null, 'stype:[null] / [新功能]\n name:[null] / [hhh]\n priority:[null] / [Critical]\n status:[null] / [处理中]\n resolved:[null] / [无法修改]\n '), ('158', '1', 'dao.hb.OAttachment', '17', '85', '2013-12-21 23:57:26', null, 'path:[null] / [_[1]1_2013_12_21_2_1.jpeg]\n '), ('159', '1', 'dao.hb.PTask', '7', '85', '2013-12-22 11:38:58', null, 'status:[null] / [已解决]\n resolved:[部分修改] / [测试未完成]\n '), ('160', '1', 'dao.hb.UUser', '8', '85', '2013-12-22 12:11:25', null, 'gid:[5] / [1]\n '), ('161', '1', 'dao.hb.PProject', '2', '85', '2013-12-23 14:37:49', null, 'aid:[null] / [9]\n '), ('162', '1', 'dao.hb.PProject', '1', '85', '2013-12-23 14:44:29', null, 'dtDue:[null] / [Wed Dec 25 00:00:00 CST 2013]\n '), ('163', '1', 'dao.hb.PTask', '8', '85', '2013-12-23 14:51:53', null, 'dtDue:[null] / [Tue Dec 24 00:00:00 CST 2013]\n '), ('164', '1', 'dao.hb.RRel', '12', '65', '2013-12-27 09:04:11', null, null), ('165', '1', 'dao.hb.RRel', '13', '65', '2013-12-27 09:04:11', null, null), ('166', '1', 'dao.hb.RRel', '14', '65', '2013-12-27 09:04:11', null, null), ('167', '1', 'dao.hb.PTask', '4', '85', '2013-12-27 17:50:13', null, 'summery:[null] / [kjkjfd@陈胜 jafdsfdsfdajf@张星炜 kjfaaff]\n '), ('168', '1', 'dao.hb.PTask', '6', '85', '2013-12-30 05:51:24', null, 'summery:[null] / [@张星炜 @陈胜 ]\n ');
COMMIT;

-- ----------------------------
--  Table structure for `m_inbox`
-- ----------------------------
DROP TABLE IF EXISTS `m_inbox`;
CREATE TABLE `m_inbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `tm_check` datetime DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `m_inbox`
-- ----------------------------
BEGIN;
INSERT INTO `m_inbox` VALUES ('1', '1', '1', null, null), ('2', '2', '1', null, null), ('3', '3', '1', null, null), ('4', '4', '1', null, null), ('5', '5', '1', null, null), ('6', '6', '1', null, null), ('7', '7', '1', null, null), ('8', '8', '1', null, null), ('9', '9', '1', null, null), ('10', '10', '1', null, null), ('11', '11', '1', null, null), ('12', '12', '1', null, null), ('13', '13', '1', null, null), ('14', '14', '1', null, null), ('15', '15', '1', null, null), ('16', '16', '1', null, null), ('17', '17', '1', null, null), ('18', '18', '1', null, null), ('19', '19', '1', null, null), ('20', '20', '1', null, null), ('21', '21', '1', null, null), ('22', '22', '1', null, null), ('23', '23', '1', null, null), ('24', '24', '1', null, null), ('25', '25', '1', null, null), ('26', '26', '1', null, null), ('27', '27', '1', null, null), ('28', '28', '1', null, null), ('29', '29', '1', null, null), ('30', '30', '1', null, null), ('31', '31', '1', null, null), ('32', '32', '1', null, null), ('33', '33', '1', null, null), ('34', '35', '1', null, null), ('35', '36', '1', null, null), ('36', '37', '1', null, null), ('37', '38', '1', null, null), ('38', '39', '1', null, null), ('39', '40', '1', null, null), ('40', '41', '1', null, null), ('41', '42', '1', null, null), ('42', '43', '1', null, null), ('43', '45', '1', null, null), ('44', '46', '1', null, null), ('45', '48', '1', null, null), ('46', '49', '1', null, null), ('47', '50', '1', null, null), ('48', '51', '1', null, null), ('49', '52', '1', null, null), ('50', '53', '1', null, null), ('51', '55', '1', null, null), ('52', '56', '1', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `m_message`
-- ----------------------------
DROP TABLE IF EXISTS `m_message`;
CREATE TABLE `m_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mid` int(11) DEFAULT NULL COMMENT 'parent message',
  `uid` int(11) DEFAULT NULL,
  `send_to` varchar(255) DEFAULT NULL,
  `uname` varchar(255) DEFAULT NULL,
  `online` int(11) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `tm_create` datetime DEFAULT NULL,
  `tm_modify` datetime DEFAULT NULL,
  `tm_reply` datetime DEFAULT NULL,
  `rname` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `m_message`
-- ----------------------------
BEGIN;
INSERT INTO `m_message` VALUES ('1', null, '1', null, '姓名1', '0', null, '说点什么吧', '是xxx是', '2012-02-25 18:11:43', null, null, null, null), ('2', null, '1', null, '姓名1', '0', null, 'eee', 'www', '2012-02-26 19:49:01', null, null, null, null), ('3', null, '5', null, '姓名5', '0', null, '', 'yyyy\nå¤ªé³æ¥tyyt', '2012-05-21 10:04:59', null, null, null, null), ('4', null, '1', null, 'sysroot', '0', null, 'rr', 'ssss', '2012-10-05 10:59:46', null, null, null, null), ('5', null, '1', null, 'sysroot', '0', null, 'dd', 'ss', '2012-10-05 11:00:20', null, null, null, null), ('6', null, '1', null, 'sysroot', '0', null, 'sss', 'ffdfdf', '2013-12-13 07:47:21', null, null, null, null), ('7', null, '1', null, 'sysroot', '0', null, 'dssss', 'fdf', '2013-12-13 07:51:19', null, null, null, null), ('8', null, '1', null, 'sysroot', '0', null, 'eee', 'wwww', '2013-12-13 08:18:54', null, null, null, null), ('9', null, '1', null, 'sysroot', '0', null, 'fddf', 'dfd', '2013-12-13 08:20:21', null, null, null, null), ('10', null, '1', null, 'sysroot', '0', null, 'df', 'fdfdfd', '2013-12-13 08:20:57', null, null, null, null), ('11', null, '1', null, 'sysroot', '0', null, 'dfd', 'dffdf', '2013-12-13 08:23:28', null, null, null, null), ('12', null, '1', null, 'sysroot', '0', null, 'fer', 'errer', '2013-12-13 08:23:46', null, null, null, null), ('13', null, '1', null, 'sysroot', '0', null, 'dff', 'dfdfdfd', '2013-12-13 08:23:54', null, null, null, null), ('14', null, '1', null, 'sysroot', '0', null, 'dfdf', 'fdff', '2013-12-13 08:23:58', null, null, null, null), ('15', null, '1', null, 'sysroot', '0', null, 'dfd', 'dfdfdf', '2013-12-13 08:24:07', null, null, null, null), ('16', null, '1', null, 'sysroot', '0', null, 'qqq', 'qww', '2013-12-13 08:32:44', null, null, null, null), ('17', null, '1', null, 'sysroot', '0', null, 'qqq', 'qwqw', '2013-12-13 08:33:04', null, null, null, null), ('18', null, '1', null, 'sysroot', '0', null, 'qwq', 'qww', '2013-12-13 08:33:09', null, null, null, null), ('19', null, '1', null, 'sysroot', '0', null, 'qwqw', 'qwqwqw', '2013-12-13 08:33:14', null, null, null, null), ('20', null, '1', null, 'sysroot', '0', null, 'qwqw', 'qwqw', '2013-12-13 08:33:19', null, null, null, null), ('21', null, '1', null, 'sysroot', '0', null, 'wqq', 'qwqqw', '2013-12-13 08:33:24', null, null, null, null), ('22', null, '1', null, 'sysroot', '0', null, 'qwqww', 'q', '2013-12-13 08:33:28', null, null, null, null), ('23', null, '1', null, 'sysroot', '0', null, 'qwq', 'wqqwwq', '2013-12-13 08:33:36', null, null, null, null), ('24', null, '1', null, 'sysroot', '0', null, 'qw', 'qwqqw', '2013-12-13 08:33:42', null, null, null, null), ('25', null, '1', null, 'sysroot', '0', null, 'qw', 'qwqwqw', '2013-12-13 08:33:48', null, null, null, null), ('26', null, '1', null, 'sysroot', '0', null, 'wqw', 'qwqw', '2013-12-13 08:33:54', null, null, null, null), ('27', null, '1', null, 'sysroot', '0', null, 'ss', 'sdfd', '2013-12-13 08:34:43', null, null, null, null), ('28', null, '1', null, 'sysroot', '0', null, 'sds', 'dss', '2013-12-13 08:36:35', null, null, null, null), ('29', null, '1', null, 'sysroot', '0', null, 'sdff', 'ss', '2013-12-13 08:42:14', null, null, null, null), ('30', null, '1', null, 'sysroot', '0', null, 'ss', 'dasda', '2013-12-13 08:45:57', null, null, null, null), ('31', null, '1', null, 'sysroot', '0', null, 'kkk', 'dff', '2013-12-13 08:47:58', null, null, null, null), ('32', null, '1', null, 'sysroot', '0', null, 'x', 'dfd', '2013-12-13 08:49:17', null, null, null, null), ('33', null, '1', null, 'sysroot', '0', null, 'sss', 'dd', '2013-12-13 08:49:34', null, null, null, null), ('34', null, '1', null, 'sysroot', '0', null, 'qqq', 'aaa', '2013-12-13 08:50:11', null, null, null, null), ('35', null, '1', null, 'sysroot', '0', null, 'fdf', 'sss', '2013-12-13 08:51:57', null, null, null, null), ('36', null, '1', null, 'sysroot', '0', null, 'dfg', 'fgdg', '2013-12-13 08:55:50', null, null, null, null), ('37', null, '1', null, 'sysroot', '0', null, 'dd', 'gffgd', '2013-12-13 08:55:54', null, null, null, null), ('38', null, '1', null, 'sysroot', '0', null, 'dfg', 'fgdgf', '2013-12-13 08:56:30', null, null, null, null), ('39', null, '1', null, 'sysroot', '0', null, 'gfdg', 'fdgdgd', '2013-12-13 08:56:34', null, null, null, null), ('40', null, '1', null, 'sysroot', '0', null, 'fgd', 'fdggd', '2013-12-13 08:56:39', null, null, null, null), ('41', null, '1', null, 'sysroot', '0', null, 'fgdg', 'dfg', '2013-12-13 08:56:44', null, null, null, null), ('42', null, '1', null, 'sysroot', '0', null, 'dfdg', 'fdgdg', '2013-12-13 08:56:49', null, null, null, null), ('43', null, '1', null, 'sysroot', '0', null, 'df', 'fdgd', '2013-12-13 08:56:53', null, null, null, null), ('44', null, '1', null, 'sysroot', '0', null, 'sf', 'sfsf', '2013-12-13 08:58:58', null, null, null, null), ('45', null, '1', null, 'sysroot', '0', null, 'd', 'sdfs', '2013-12-13 08:59:09', null, null, null, null), ('46', null, '1', null, 'sysroot', '0', null, 'ff', 'fggg', '2013-12-13 08:59:41', null, null, null, null), ('47', null, '1', null, 'sysroot', '0', null, 'f', 'dfsfd', '2013-12-13 09:00:33', null, null, null, null), ('48', null, '1', null, 'sysroot', '0', null, 'dfds', 'ffdf', '2013-12-13 09:00:39', null, null, null, null), ('49', null, '1', null, 'sysroot', '0', null, 'fdd', 'fdffs', '2013-12-13 09:00:52', null, null, null, null), ('50', null, '1', null, 'sysroot', '0', null, 'dfsf', 'sfdsfs', '2013-12-13 09:01:00', null, null, null, null), ('51', null, '1', null, 'sysroot', '0', null, 'sdf', 'sdfsf', '2013-12-13 09:01:09', null, null, null, null), ('52', null, '1', null, 'sysroot', '0', null, 'sdfd', 'dsffdsf', '2013-12-13 09:01:25', null, null, null, null), ('53', null, '1', null, 'sysroot', '0', null, 'sdf', 'sffsffsf', '2013-12-13 09:01:38', null, null, null, null), ('54', null, '1', null, 'sysroot', '0', null, '成都f', 'f电视发射塔dfs\ndfsfs', '2013-12-15 21:19:18', null, null, null, null), ('55', null, '1', null, 'sysroot', '0', null, 'gdgg', 'dgdfdsfsfdgsdgs\ndfgsdgsgsdg\n个非官方', '2013-12-15 21:19:34', null, null, null, null), ('56', null, '1', null, 'sysroot', '0', null, 'fdsfddf', 'fdsfdsfsfsfsdf\n\nsdfdsf大法师法十多个', '2013-12-15 21:19:59', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `n_base`
-- ----------------------------
DROP TABLE IF EXISTS `n_base`;
CREATE TABLE `n_base` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `vid` int(10) DEFAULT NULL,
  `itype` int(10) DEFAULT NULL,
  `language` varchar(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `status_publish` int(10) DEFAULT NULL,
  `status_comment` int(10) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `tnid` int(10) DEFAULT NULL,
  `pnid` int(10) DEFAULT NULL,
  `ord` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `n_image`
-- ----------------------------
DROP TABLE IF EXISTS `n_image`;
CREATE TABLE `n_image` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nid` int(10) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `detail` text,
  `width` int(10) DEFAULT NULL,
  `height` int(10) DEFAULT NULL,
  `fsize` int(10) DEFAULT NULL,
  `uri` varchar(255) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `n_menu`
-- ----------------------------
DROP TABLE IF EXISTS `n_menu`;
CREATE TABLE `n_menu` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nid` int(10) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `ingredients` varchar(255) DEFAULT NULL,
  `accessories` varchar(255) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `price_unit` varchar(255) DEFAULT NULL,
  `runtime` int(12) DEFAULT NULL,
  `summery` text,
  `style` varchar(255) DEFAULT NULL,
  `uri_media` varchar(255) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `n_poster`
-- ----------------------------
DROP TABLE IF EXISTS `n_poster`;
CREATE TABLE `n_poster` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` mediumint(10) DEFAULT NULL,
  `rid` int(10) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sms` varchar(255) DEFAULT NULL,
  `body` text,
  `dt_begin` datetime DEFAULT NULL,
  `dt_end` datetime DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `n_restaurant`
-- ----------------------------
DROP TABLE IF EXISTS `n_restaurant`;
CREATE TABLE `n_restaurant` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nid` int(10) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `outgoing` int(10) DEFAULT NULL,
  `summery` text,
  `homepage` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `desc_ticket` text,
  `desc_open` text,
  `desc_traffic` text,
  `uri_media` varchar(255) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `n_sort`
-- ----------------------------
DROP TABLE IF EXISTS `n_sort`;
CREATE TABLE `n_sort` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `itype` int(11) DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1514 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `n_sort`
-- ----------------------------
BEGIN;
INSERT INTO `n_sort` VALUES ('712', '36', null, null, '1', '菜品分类', null, '2013-01-06 15:56:58', null), ('713', '36', '712', null, '1', '凉菜类', null, '2013-01-06 15:56:58', null), ('714', '36', '712', null, '1', '热菜类', null, '2013-01-06 15:56:58', null), ('715', '36', '714', null, '1', '猪肉', null, '2013-01-06 15:56:58', null), ('716', '36', '714', null, '1', '牛肉', null, '2013-01-06 15:56:58', null), ('717', '36', '714', null, '1', '羊肉', null, '2013-01-06 15:56:58', null), ('718', '36', '714', null, '1', '禽蛋类', null, '2013-01-06 15:56:58', null), ('719', '36', '714', null, '1', '其他肉类', null, '2013-01-06 15:56:58', null), ('720', '36', '714', null, '1', '菇菌类', null, '2013-01-06 15:56:58', null), ('721', '36', '714', null, '1', '鲍鱼类', null, '2013-01-06 15:56:58', null), ('722', '36', '714', null, '1', '鱼翅类', null, '2013-01-06 15:56:58', null), ('723', '36', '714', null, '1', '海鲜类', null, '2013-01-06 15:56:58', null), ('724', '36', '714', null, '1', '蔬菜类', null, '2013-01-06 15:56:58', null), ('725', '36', '714', null, '1', '豆腐类', null, '2013-01-06 15:56:58', null), ('726', '36', '714', null, '1', '燕窝类', null, '2013-01-06 15:56:58', null), ('727', '36', '728', null, '1', '汤', null, '2013-01-06 15:56:58', null), ('728', '36', '712', null, '1', '汤羹粥煲类', null, '2013-01-06 15:56:58', null), ('729', '36', '728', null, '1', '粥', null, '2013-01-06 15:56:58', null), ('730', '36', '728', null, '1', '羹', null, '2013-01-06 15:56:58', null), ('731', '36', '712', null, '1', '主食和小吃', null, '2013-01-06 15:56:58', null), ('732', '36', '712', null, '1', '煲', null, '2013-01-06 15:56:58', null), ('733', '36', '734', null, '1', '白酒', null, '2013-01-06 15:56:58', null), ('734', '36', null, null, '1', '酒精类饮品', null, '2013-01-06 15:56:58', null), ('735', '36', '734', null, '1', '葡萄酒', null, '2013-01-06 15:56:58', null), ('736', '36', '734', null, '1', '黄酒、啤酒', null, '2013-01-06 15:56:58', null), ('737', '36', '738', null, '1', '茶、茶类饮品', null, '2013-01-06 15:56:58', null), ('738', '36', null, null, '1', '不含酒精类的饮品', null, '2013-01-06 15:56:58', null), ('739', '36', '738', null, '1', '矿泉水', null, '2013-01-06 15:56:58', null), ('740', '36', '738', null, '1', '咖啡、咖啡类饮品', null, '2013-01-06 15:56:58', null), ('741', '36', '738', null, '1', '苏打水、其他饮料', null, '2013-01-06 15:56:58', null), ('742', '36', '738', null, '1', '果蔬汁', null, '2013-01-06 15:56:58', null), ('743', '37', null, null, '1', ' Types of Courses', null, '2013-01-06 15:57:04', null), ('744', '37', '743', null, '1', ' Cold Dishes', null, '2013-01-06 15:57:04', null), ('745', '37', '743', null, '1', ' Hot Dishes', null, '2013-01-06 15:57:04', null), ('746', '37', '745', null, '1', ' (Pork)', null, '2013-01-06 15:57:04', null), ('747', '37', '745', null, '1', ' (Beef)', null, '2013-01-06 15:57:04', null), ('748', '37', '745', null, '1', ' (Lamb)', null, '2013-01-06 15:57:04', null), ('749', '37', '745', null, '1', ' (Poultry and Eggs)', null, '2013-01-06 15:57:04', null), ('750', '37', '745', null, '1', ' (Other Meat)', null, '2013-01-06 15:57:04', null), ('751', '37', '745', null, '1', ' (Mushrooms)', null, '2013-01-06 15:57:04', null), ('752', '37', '745', null, '1', ' (Abalone)', null, '2013-01-06 15:57:04', null), ('753', '37', '745', null, '1', ' (Shark Fins)', null, '2013-01-06 15:57:04', null), ('754', '37', '745', null, '1', ' (Seafood)', null, '2013-01-06 15:57:04', null), ('755', '37', '745', null, '1', ' (Vegetables)', null, '2013-01-06 15:57:04', null), ('756', '37', '745', null, '1', ' (Tofu)', null, '2013-01-06 15:57:04', null), ('757', '37', '745', null, '1', ' (Bird’s Nest Soup)', null, '2013-01-06 15:57:04', null), ('758', '37', '759', null, '1', ' (Soups)', null, '2013-01-06 15:57:04', null), ('759', '37', '743', null, '1', ' Soups, Congees & Casseroles', null, '2013-01-06 15:57:04', null), ('760', '37', '759', null, '1', ' (Congees)', null, '2013-01-06 15:57:04', null), ('761', '37', '759', null, '1', ' (Thick Soups)', null, '2013-01-06 15:57:04', null), ('762', '37', '743', null, '1', ' Main Food & Snacks', null, '2013-01-06 15:57:04', null), ('763', '37', '743', null, '1', ' (Casseroles)', null, '2013-01-06 15:57:04', null), ('764', '37', '765', null, '1', ' (Liquor)', null, '2013-01-06 15:57:04', null), ('765', '37', null, null, '1', 'Alcoholic Beverages', null, '2013-01-06 15:57:04', null), ('766', '37', '765', null, '1', ' (Wine)', null, '2013-01-06 15:57:04', null), ('767', '37', '765', null, '1', ' (Yellow Wine & Beer)', null, '2013-01-06 15:57:04', null), ('768', '37', '769', null, '1', ' (Tea & Tea-Based Drinks)', null, '2013-01-06 15:57:04', null), ('769', '37', null, null, '1', ' Non-Alcoholic Beverage', null, '2013-01-06 15:57:04', null), ('770', '37', '769', null, '1', ' (Mineral Water)', null, '2013-01-06 15:57:04', null), ('771', '37', '769', null, '1', ' (Coffee & Coffee-Based Drinks)', null, '2013-01-06 15:57:04', null), ('772', '37', '769', null, '1', ' (Sodas & Other Drinks)', null, '2013-01-06 15:57:04', null), ('773', '37', '769', null, '1', ' (Juices)', null, '2013-01-06 15:57:04', null), ('774', '39', null, null, '1', '菜品分类', null, '2013-01-06 16:00:40', null), ('775', '39', '774', null, '1', '凉菜类', null, '2013-01-06 16:00:40', null), ('776', '39', '774', null, '1', '热菜类', null, '2013-01-06 16:00:40', null), ('777', '39', '776', null, '1', '猪肉', null, '2013-01-06 16:00:40', null), ('778', '39', '776', null, '1', '牛肉', null, '2013-01-06 16:00:40', null), ('779', '39', '776', null, '1', '羊肉', null, '2013-01-06 16:00:40', null), ('780', '39', '776', null, '1', '禽蛋类', null, '2013-01-06 16:00:40', null), ('781', '39', '776', null, '1', '其他肉类', null, '2013-01-06 16:00:40', null), ('782', '39', '776', null, '1', '菇菌类', null, '2013-01-06 16:00:40', null), ('783', '39', '776', null, '1', '鲍鱼类', null, '2013-01-06 16:00:40', null), ('784', '39', '776', null, '1', '鱼翅类', null, '2013-01-06 16:00:40', null), ('785', '39', '776', null, '1', '海鲜类', null, '2013-01-06 16:00:40', null), ('786', '39', '776', null, '1', '蔬菜类', null, '2013-01-06 16:00:40', null), ('787', '39', '776', null, '1', '豆腐类', null, '2013-01-06 16:00:40', null), ('788', '39', '776', null, '1', '燕窝类', null, '2013-01-06 16:00:40', null), ('789', '39', '790', null, '1', '汤', null, '2013-01-06 16:00:40', null), ('790', '39', '774', null, '1', '汤羹粥煲类', null, '2013-01-06 16:00:40', null), ('791', '39', '790', null, '1', '粥', null, '2013-01-06 16:00:40', null), ('792', '39', '790', null, '1', '羹', null, '2013-01-06 16:00:40', null), ('793', '39', '774', null, '1', '主食和小吃', null, '2013-01-06 16:00:40', null), ('794', '39', '774', null, '1', '煲', null, '2013-01-06 16:00:40', null), ('795', '39', '796', null, '1', '白酒', null, '2013-01-06 16:00:40', null), ('796', '39', null, null, '1', '酒精类饮品', null, '2013-01-06 16:00:40', null), ('797', '39', '796', null, '1', '葡萄酒', null, '2013-01-06 16:00:40', null), ('798', '39', '796', null, '1', '黄酒、啤酒', null, '2013-01-06 16:00:40', null), ('799', '39', '800', null, '1', '茶、茶类饮品', null, '2013-01-06 16:00:40', null), ('800', '39', null, null, '1', '不含酒精类的饮品', null, '2013-01-06 16:00:40', null), ('801', '39', '800', null, '1', '矿泉水', null, '2013-01-06 16:00:40', null), ('802', '39', '800', null, '1', '咖啡、咖啡类饮品', null, '2013-01-06 16:00:40', null), ('803', '39', '800', null, '1', '苏打水、其他饮料', null, '2013-01-06 16:00:40', null), ('804', '39', '800', null, '1', '果蔬汁', null, '2013-01-06 16:00:40', null), ('805', '40', null, null, '1', ' Types of Courses', null, '2013-01-06 16:00:43', null), ('806', '40', '805', null, '1', ' Cold Dishes', null, '2013-01-06 16:00:43', null), ('807', '40', '805', null, '1', ' Hot Dishes', null, '2013-01-06 16:00:43', null), ('808', '40', '807', null, '1', ' (Pork)', null, '2013-01-06 16:00:43', null), ('809', '40', '807', null, '1', ' (Beef)', null, '2013-01-06 16:00:43', null), ('810', '40', '807', null, '1', ' (Lamb)', null, '2013-01-06 16:00:43', null), ('811', '40', '807', null, '1', ' (Poultry and Eggs)', null, '2013-01-06 16:00:43', null), ('812', '40', '807', null, '1', ' (Other Meat)', null, '2013-01-06 16:00:43', null), ('813', '40', '807', null, '1', ' (Mushrooms)', null, '2013-01-06 16:00:43', null), ('814', '40', '807', null, '1', ' (Abalone)', null, '2013-01-06 16:00:43', null), ('815', '40', '807', null, '1', ' (Shark Fins)', null, '2013-01-06 16:00:43', null), ('816', '40', '807', null, '1', ' (Seafood)', null, '2013-01-06 16:00:43', null), ('817', '40', '807', null, '1', ' (Vegetables)', null, '2013-01-06 16:00:43', null), ('818', '40', '807', null, '1', ' (Tofu)', null, '2013-01-06 16:00:43', null), ('819', '40', '807', null, '1', ' (Bird’s Nest Soup)', null, '2013-01-06 16:00:43', null), ('820', '40', '821', null, '1', ' (Soups)', null, '2013-01-06 16:00:43', null), ('821', '40', '805', null, '1', ' Soups, Congees & Casseroles', null, '2013-01-06 16:00:43', null), ('822', '40', '821', null, '1', ' (Congees)', null, '2013-01-06 16:00:43', null), ('823', '40', '821', null, '1', ' (Thick Soups)', null, '2013-01-06 16:00:43', null), ('824', '40', '805', null, '1', ' Main Food & Snacks', null, '2013-01-06 16:00:43', null), ('825', '40', '805', null, '1', ' (Casseroles)', null, '2013-01-06 16:00:43', null), ('826', '40', '827', null, '1', ' (Liquor)', null, '2013-01-06 16:00:43', null), ('827', '40', null, null, '1', 'Alcoholic Beverages', null, '2013-01-06 16:00:43', null), ('828', '40', '827', null, '1', ' (Wine)', null, '2013-01-06 16:00:43', null), ('829', '40', '827', null, '1', ' (Yellow Wine & Beer)', null, '2013-01-06 16:00:43', null), ('830', '40', '831', null, '1', ' (Tea & Tea-Based Drinks)', null, '2013-01-06 16:00:43', null), ('831', '40', null, null, '1', ' Non-Alcoholic Beverage', null, '2013-01-06 16:00:43', null), ('832', '40', '831', null, '1', ' (Mineral Water)', null, '2013-01-06 16:00:43', null), ('833', '40', '831', null, '1', ' (Coffee & Coffee-Based Drinks)', null, '2013-01-06 16:00:43', null), ('834', '40', '831', null, '1', ' (Sodas & Other Drinks)', null, '2013-01-06 16:00:43', null), ('835', '40', '831', null, '1', ' (Juices)', null, '2013-01-06 16:00:43', null), ('1270', '43', null, null, '1', '菜品分类', null, '2013-01-07 19:50:47', null), ('1271', '43', '1270', null, '1', '凉菜类', null, '2013-01-07 19:50:47', null), ('1272', '43', '1270', null, '1', '热菜类', null, '2013-01-07 19:50:47', null), ('1273', '43', '1272', null, '1', '猪肉', null, '2013-01-07 19:50:47', null), ('1274', '43', '1272', null, '1', '牛肉', null, '2013-01-07 19:50:47', null), ('1275', '43', '1272', null, '1', '羊肉', null, '2013-01-07 19:50:47', null), ('1276', '43', '1272', null, '1', '禽蛋类', null, '2013-01-07 19:50:47', null), ('1277', '43', '1272', null, '1', '其他肉类', null, '2013-01-07 19:50:47', null), ('1278', '43', '1272', null, '1', '菇菌类', null, '2013-01-07 19:50:47', null), ('1279', '43', '1272', null, '1', '鲍鱼类', null, '2013-01-07 19:50:47', null), ('1280', '43', '1272', null, '1', '鱼翅类', null, '2013-01-07 19:50:47', null), ('1281', '43', '1272', null, '1', '海鲜类', null, '2013-01-07 19:50:47', null), ('1282', '43', '1272', null, '1', '蔬菜类', null, '2013-01-07 19:50:47', null), ('1283', '43', '1272', null, '1', '豆腐类', null, '2013-01-07 19:50:47', null), ('1284', '43', '1272', null, '1', '燕窝类', null, '2013-01-07 19:50:47', null), ('1285', '43', '1286', null, '1', '汤', null, '2013-01-07 19:50:47', null), ('1286', '43', '1270', null, '1', '汤羹粥煲类', null, '2013-01-07 19:50:47', null), ('1287', '43', '1286', null, '1', '粥', null, '2013-01-07 19:50:47', null), ('1288', '43', '1286', null, '1', '羹', null, '2013-01-07 19:50:47', null), ('1289', '43', '1270', null, '1', '主食和小吃', null, '2013-01-07 19:50:47', null), ('1290', '43', '1270', null, '1', '煲', null, '2013-01-07 19:50:47', null), ('1291', '43', '1292', null, '1', '白酒', null, '2013-01-07 19:50:47', null), ('1292', '43', null, null, '1', '酒精类饮品', null, '2013-01-07 19:50:47', null), ('1293', '43', '1292', null, '1', '葡萄酒', null, '2013-01-07 19:50:47', null), ('1294', '43', '1292', null, '1', '黄酒、啤酒', null, '2013-01-07 19:50:47', null), ('1295', '43', '1296', null, '1', '茶、茶类饮品', null, '2013-01-07 19:50:47', null), ('1296', '43', null, null, '1', '不含酒精类的饮品', null, '2013-01-07 19:50:47', null), ('1297', '43', '1296', null, '1', '矿泉水', null, '2013-01-07 19:50:47', null), ('1298', '43', '1296', null, '1', '咖啡、咖啡类饮品', null, '2013-01-07 19:50:47', null), ('1299', '43', '1296', null, '1', '苏打水、其他饮料', null, '2013-01-07 19:50:47', null), ('1300', '43', '1296', null, '1', '果蔬汁', null, '2013-01-07 19:50:47', null), ('1301', '44', null, null, '1', ' Types of Courses', null, '2013-01-07 19:50:47', null), ('1302', '44', '1301', null, '1', ' Cold Dishes', null, '2013-01-07 19:50:47', null), ('1303', '44', '1301', null, '1', ' Hot Dishes', null, '2013-01-07 19:50:47', null), ('1304', '44', '1303', null, '1', ' (Pork)', null, '2013-01-07 19:50:47', null), ('1305', '44', '1303', null, '1', ' (Beef)', null, '2013-01-07 19:50:47', null), ('1306', '44', '1303', null, '1', ' (Lamb)', null, '2013-01-07 19:50:47', null), ('1307', '44', '1303', null, '1', ' (Poultry and Eggs)', null, '2013-01-07 19:50:47', null), ('1308', '44', '1303', null, '1', ' (Other Meat)', null, '2013-01-07 19:50:47', null), ('1309', '44', '1303', null, '1', ' (Mushrooms)', null, '2013-01-07 19:50:47', null), ('1310', '44', '1303', null, '1', ' (Abalone)', null, '2013-01-07 19:50:47', null), ('1311', '44', '1303', null, '1', ' (Shark Fins)', null, '2013-01-07 19:50:47', null), ('1312', '44', '1303', null, '1', ' (Seafood)', null, '2013-01-07 19:50:47', null), ('1313', '44', '1303', null, '1', ' (Vegetables)', null, '2013-01-07 19:50:47', null), ('1314', '44', '1303', null, '1', ' (Tofu)', null, '2013-01-07 19:50:47', null), ('1315', '44', '1303', null, '1', ' (Bird’s Nest Soup)', null, '2013-01-07 19:50:47', null), ('1316', '44', '1317', null, '1', ' (Soups)', null, '2013-01-07 19:50:47', null), ('1317', '44', '1301', null, '1', ' Soups, Congees & Casseroles', null, '2013-01-07 19:50:47', null), ('1318', '44', '1317', null, '1', ' (Congees)', null, '2013-01-07 19:50:47', null), ('1319', '44', '1317', null, '1', ' (Thick Soups)', null, '2013-01-07 19:50:47', null), ('1320', '44', '1301', null, '1', ' Main Food & Snacks', null, '2013-01-07 19:50:47', null), ('1321', '44', '1301', null, '1', ' (Casseroles)', null, '2013-01-07 19:50:47', null), ('1322', '44', '1323', null, '1', ' (Liquor)', null, '2013-01-07 19:50:47', null), ('1323', '44', null, null, '1', 'Alcoholic Beverages', null, '2013-01-07 19:50:47', null), ('1324', '44', '1323', null, '1', ' (Wine)', null, '2013-01-07 19:50:47', null), ('1325', '44', '1323', null, '1', ' (Yellow Wine & Beer)', null, '2013-01-07 19:50:47', null), ('1326', '44', '1327', null, '1', ' (Tea & Tea-Based Drinks)', null, '2013-01-07 19:50:47', null), ('1327', '44', null, null, '1', ' Non-Alcoholic Beverage', null, '2013-01-07 19:50:47', null), ('1328', '44', '1327', null, '1', ' (Mineral Water)', null, '2013-01-07 19:50:47', null), ('1329', '44', '1327', null, '1', ' (Coffee & Coffee-Based Drinks)', null, '2013-01-07 19:50:47', null), ('1330', '44', '1327', null, '1', ' (Sodas & Other Drinks)', null, '2013-01-07 19:50:47', null), ('1331', '44', '1327', null, '1', ' (Juices)', null, '2013-01-07 19:50:47', null), ('1394', '33725', null, null, '1', '菜品分类', null, '2013-03-26 16:02:13', null), ('1395', '33725', '1394', null, '1', '凉菜类', null, '2013-03-26 16:02:13', null), ('1396', '33725', '1394', null, '1', '热菜类', null, '2013-03-26 16:02:13', null), ('1397', '33725', '1396', null, '1', '猪肉', null, '2013-03-26 16:02:13', null), ('1398', '33725', '1396', null, '1', '牛肉', null, '2013-03-26 16:02:13', null), ('1399', '33725', '1396', null, '1', '羊肉', null, '2013-03-26 16:02:13', null), ('1400', '33725', '1396', null, '1', '禽蛋类', null, '2013-03-26 16:02:13', null), ('1401', '33725', '1396', null, '1', '其他肉类', null, '2013-03-26 16:02:13', null), ('1402', '33725', '1396', null, '1', '菇菌类', null, '2013-03-26 16:02:13', null), ('1403', '33725', '1396', null, '1', '鲍鱼类', null, '2013-03-26 16:02:13', null), ('1404', '33725', '1396', null, '1', '鱼翅类', null, '2013-03-26 16:02:13', null), ('1405', '33725', '1396', null, '1', '海鲜类', null, '2013-03-26 16:02:13', null), ('1406', '33725', '1396', null, '1', '蔬菜类', null, '2013-03-26 16:02:13', null), ('1407', '33725', '1396', null, '1', '豆腐类', null, '2013-03-26 16:02:13', null), ('1408', '33725', '1396', null, '1', '燕窝类', null, '2013-03-26 16:02:13', null), ('1409', '33725', '1410', null, '1', '汤', null, '2013-03-26 16:02:13', null), ('1410', '33725', '1394', null, '1', '汤羹粥煲类', null, '2013-03-26 16:02:13', null), ('1411', '33725', '1410', null, '1', '粥', null, '2013-03-26 16:02:13', null), ('1412', '33725', '1410', null, '1', '羹', null, '2013-03-26 16:02:13', null), ('1413', '33725', '1394', null, '1', '主食和小吃', null, '2013-03-26 16:02:13', null), ('1414', '33725', '1394', null, '1', '煲', null, '2013-03-26 16:02:13', null), ('1415', '33725', '1416', null, '1', '白酒', null, '2013-03-26 16:02:13', null), ('1416', '33725', null, null, '1', '酒精类饮品', null, '2013-03-26 16:02:13', null), ('1417', '33725', '1416', null, '1', '葡萄酒', null, '2013-03-26 16:02:13', null), ('1418', '33725', '1416', null, '1', '黄酒、啤酒', null, '2013-03-26 16:02:13', null), ('1419', '33725', '1420', null, '1', '茶、茶类饮品', null, '2013-03-26 16:02:13', null), ('1420', '33725', null, null, '1', '不含酒精类的饮品', null, '2013-03-26 16:02:13', null), ('1421', '33725', '1420', null, '1', '矿泉水', null, '2013-03-26 16:02:13', null), ('1422', '33725', '1420', null, '1', '咖啡、咖啡类饮品', null, '2013-03-26 16:02:13', null), ('1423', '33725', '1420', null, '1', '苏打水、其他饮料', null, '2013-03-26 16:02:13', null), ('1424', '33725', '1420', null, '1', '果蔬汁', null, '2013-03-26 16:02:13', null), ('1425', '33726', null, null, '1', ' Types of Courses', null, '2013-03-26 16:02:14', null), ('1426', '33726', '1425', null, '1', ' Cold Dishes', null, '2013-03-26 16:02:14', null), ('1427', '33726', '1425', null, '1', ' Hot Dishes', null, '2013-03-26 16:02:14', null), ('1428', '33726', '1427', null, '1', ' (Pork)', null, '2013-03-26 16:02:14', null), ('1429', '33726', '1427', null, '1', ' (Beef)', null, '2013-03-26 16:02:14', null), ('1430', '33726', '1427', null, '1', ' (Lamb)', null, '2013-03-26 16:02:14', null), ('1431', '33726', '1427', null, '1', ' (Poultry and Eggs)', null, '2013-03-26 16:02:14', null), ('1432', '33726', '1427', null, '1', ' (Other Meat)', null, '2013-03-26 16:02:14', null), ('1433', '33726', '1427', null, '1', ' (Mushrooms)', null, '2013-03-26 16:02:14', null), ('1434', '33726', '1427', null, '1', ' (Abalone)', null, '2013-03-26 16:02:14', null), ('1435', '33726', '1427', null, '1', ' (Shark Fins)', null, '2013-03-26 16:02:14', null), ('1436', '33726', '1427', null, '1', ' (Seafood)', null, '2013-03-26 16:02:14', null), ('1437', '33726', '1427', null, '1', ' (Vegetables)', null, '2013-03-26 16:02:14', null), ('1438', '33726', '1427', null, '1', ' (Tofu)', null, '2013-03-26 16:02:14', null), ('1439', '33726', '1427', null, '1', ' (Bird’s Nest Soup)', null, '2013-03-26 16:02:14', null), ('1440', '33726', '1441', null, '1', ' (Soups)', null, '2013-03-26 16:02:14', null), ('1441', '33726', '1425', null, '1', ' Soups, Congees & Casseroles', null, '2013-03-26 16:02:14', null), ('1442', '33726', '1441', null, '1', ' (Congees)', null, '2013-03-26 16:02:14', null), ('1443', '33726', '1441', null, '1', ' (Thick Soups)', null, '2013-03-26 16:02:14', null), ('1444', '33726', '1425', null, '1', ' Main Food & Snacks', null, '2013-03-26 16:02:14', null), ('1445', '33726', '1425', null, '1', ' (Casseroles)', null, '2013-03-26 16:02:14', null), ('1446', '33726', '1447', null, '1', ' (Liquor)', null, '2013-03-26 16:02:14', null), ('1447', '33726', null, null, '1', 'Alcoholic Beverages', null, '2013-03-26 16:02:14', null), ('1448', '33726', '1447', null, '1', ' (Wine)', null, '2013-03-26 16:02:14', null), ('1449', '33726', '1447', null, '1', ' (Yellow Wine & Beer)', null, '2013-03-26 16:02:14', null), ('1450', '33726', '1451', null, '1', ' (Tea & Tea-Based Drinks)', null, '2013-03-26 16:02:14', null), ('1451', '33726', null, null, '1', ' Non-Alcoholic Beverage', null, '2013-03-26 16:02:14', null), ('1452', '33726', '1451', null, '1', ' (Mineral Water)', null, '2013-03-26 16:02:14', null), ('1453', '33726', '1451', null, '1', ' (Coffee & Coffee-Based Drinks)', null, '2013-03-26 16:02:14', null), ('1454', '33726', '1451', null, '1', ' (Sodas & Other Drinks)', null, '2013-03-26 16:02:14', null), ('1455', '33726', '1451', null, '1', ' (Juices)', null, '2013-03-26 16:02:14', null), ('1456', '44238', null, null, '1', '菜品分类', null, '2013-03-26 16:06:05', null), ('1457', '44238', '1456', null, '1', '开胃菜（头盘及沙拉类）', null, '2013-03-26 16:06:05', null), ('1458', '44238', '1456', null, '1', '汤类', null, '2013-03-26 16:06:05', null), ('1459', '44238', '1456', null, '1', '副菜', null, '2013-03-26 16:06:05', null), ('1460', '44238', '1456', null, '1', '主菜', null, '2013-03-26 16:06:05', null), ('1461', '44238', '1460', null, '1', '禽蛋类', null, '2013-03-26 16:06:05', null), ('1462', '44238', '1460', null, '1', '牛肉类', null, '2013-03-26 16:06:05', null), ('1463', '44238', '1460', null, '1', '猪肉类', null, '2013-03-26 16:06:05', null), ('1464', '44238', '1460', null, '1', '羊肉类', null, '2013-03-26 16:06:05', null), ('1465', '44238', '1460', null, '1', '鱼、海鲜类', null, '2013-03-26 16:06:05', null), ('1466', '44238', '1456', null, '1', '配菜', null, '2013-03-26 16:06:05', null), ('1467', '44238', '1466', null, '1', '面、粉类', null, '2013-03-26 16:06:05', null), ('1468', '44238', '1466', null, '1', '其他配菜', null, '2013-03-26 16:06:05', null), ('1469', '44238', '1466', null, '1', '面包类', null, '2013-03-26 16:06:05', null), ('1470', '44238', '1456', null, '1', '甜点', null, '2013-03-26 16:06:05', null), ('1471', '44238', '1470', null, '1', '冰品甜点', null, '2013-03-26 16:06:05', null), ('1472', '44238', '1470', null, '1', '糕点、饼干及其他', null, '2013-03-26 16:06:05', null), ('1473', '44238', '1474', null, '1', '白兰地与威士忌', null, '2013-03-26 16:06:05', null), ('1474', '44238', null, null, '1', '洋酒', null, '2013-03-26 16:06:05', null), ('1475', '44238', '1473', null, '1', '威士忌', null, '2013-03-26 16:06:05', null), ('1476', '44238', '1473', null, '1', '白兰地', null, '2013-03-26 16:06:05', null), ('1477', '44238', '1474', null, '1', '伏特加、龙舌兰', null, '2013-03-26 16:06:05', null), ('1478', '44238', '1474', null, '1', '金酒与朗姆酒', null, '2013-03-26 16:06:05', null), ('1479', '44238', '1474', null, '1', '啤酒、清酒', null, '2013-03-26 16:06:05', null), ('1480', '44238', '1474', null, '1', '利口酒与开胃酒', null, '2013-03-26 16:06:05', null), ('1481', '44238', '1474', null, '1', '红酒', null, '2013-03-26 16:06:05', null), ('1482', '44238', '1474', null, '1', '鸡尾酒、其他混合性酒', null, '2013-03-26 16:06:05', null), ('1483', '44238', '1474', null, '1', '雪利酒', null, '2013-03-26 16:06:05', null), ('1484', '44238', '1474', null, '1', '香槟', null, '2013-03-26 16:06:05', null), ('1485', '44239', null, null, '1', ' Types of Courses', null, '2013-03-26 16:06:05', null), ('1486', '44239', '1485', null, '1', 'Appetizers & Salads', null, '2013-03-26 16:06:05', null), ('1487', '44239', '1485', null, '1', ' (Soups)', null, '2013-03-26 16:06:05', null), ('1488', '44239', '1485', null, '1', ' Entrées', null, '2013-03-26 16:06:05', null), ('1489', '44239', '1485', null, '1', ' Main Courses', null, '2013-03-26 16:06:05', null), ('1490', '44239', '1489', null, '1', ' (Poultry & Eggs)', null, '2013-03-26 16:06:05', null), ('1491', '44239', '1489', null, '1', ' (Beef)', null, '2013-03-26 16:06:05', null), ('1492', '44239', '1489', null, '1', ' (Pork)', null, '2013-03-26 16:06:05', null), ('1493', '44239', '1489', null, '1', ' (Lamb)', null, '2013-03-26 16:06:05', null), ('1494', '44239', '1489', null, '1', ' (Fish & Seafood)', null, '2013-03-26 16:06:05', null), ('1495', '44239', '1485', null, '1', ' Side Dishes', null, '2013-03-26 16:06:05', null), ('1496', '44239', '1495', null, '1', ' (Noodles & Pastas)', null, '2013-03-26 16:06:05', null), ('1497', '44239', '1495', null, '1', ' (Other Sides)', null, '2013-03-26 16:06:05', null), ('1498', '44239', '1495', null, '1', ' (Breads)', null, '2013-03-26 16:06:05', null), ('1499', '44239', '1485', null, '1', ' Desserts', null, '2013-03-26 16:06:05', null), ('1500', '44239', '1499', null, '1', ' (Iced Desserts)', null, '2013-03-26 16:06:05', null), ('1501', '44239', '1499', null, '1', ' (Cakes, Cookie & Others)', null, '2013-03-26 16:06:05', null), ('1502', '44239', '1503', null, '1', ' Brandy & Whisky', null, '2013-03-26 16:06:05', null), ('1503', '44239', null, null, '1', ' Imported Wines', null, '2013-03-26 16:06:05', null), ('1504', '44239', '1502', null, '1', ' (Whiskey)', null, '2013-03-26 16:06:05', null), ('1505', '44239', '1502', null, '1', ' (Brandy)', null, '2013-03-26 16:06:05', null), ('1506', '44239', '1503', null, '1', ' (Vodka & Tequila)', null, '2013-03-26 16:06:05', null), ('1507', '44239', '1503', null, '1', ' Gin & Rum', null, '2013-03-26 16:06:05', null), ('1508', '44239', '1503', null, '1', ' (Beer & Sake)', null, '2013-03-26 16:06:05', null), ('1509', '44239', '1503', null, '1', 'Liqueur & Aperitifs', null, '2013-03-26 16:06:05', null), ('1510', '44239', '1503', null, '1', ' (Red Wine)', null, '2013-03-26 16:06:05', null), ('1511', '44239', '1503', null, '1', ' (Cocktail & Other Mixed Drinks)', null, '2013-03-26 16:06:05', null), ('1512', '44239', '1503', null, '1', ' (Sherry)', null, '2013-03-26 16:06:05', null), ('1513', '44239', '1503', null, '1', ' (Champagne)', null, '2013-03-26 16:06:05', null);
COMMIT;

-- ----------------------------
--  Table structure for `o_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `o_attachment`;
CREATE TABLE `o_attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entity_name` varchar(255) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `stype` varchar(255) DEFAULT NULL COMMENT '类型',
  `suffix` varchar(255) DEFAULT NULL,
  `spec` varchar(255) DEFAULT NULL,
  `size` int(11) DEFAULT NULL COMMENT '文件大小',
  `path` varchar(2048) DEFAULT NULL COMMENT '路径',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL COMMENT '状态',
  `tm_create` datetime DEFAULT NULL,
  `tm_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `o_attachment`
-- ----------------------------
BEGIN;
INSERT INTO `o_attachment` VALUES ('1', 'dao.hb.OLocation', '339', '梅兰芳大剧院平面图', '2', null, null, null, '_[2012_05_21_2]t1.html', null, '1', null, '2012-05-21 10:30:27'), ('2', 'dao.hb.OAttachment', '340', '中科科仪正门', '1', null, null, null, '_[1]1_2013_03_11_2_SH100215.jpg', null, '1', null, '2012-05-21 10:30:46'), ('3', 'dao.hb.OLocation', '339', '梅兰芳大剧院外观', '1', null, null, null, '_[1]1_2013_12_12_5_pic.jpg', null, '1', null, '2012-05-21 10:31:31'), ('5', 'dao.hb.OLocation', '339', '中科6层平面图', '2', null, null, null, '_[2012_08_07_3]e1.jpg', null, '1', '2012-08-07 10:49:35', '2012-08-07 10:50:35'), ('6', 'dao.hb.OAttachment', '5', 'bind', '3', null, null, null, '\\6.js', null, '1', '2012-08-20 11:27:20', null), ('7', 'dao.hb.OAttachment', '5', 'bind', '3', null, null, null, '\\7.js', null, '1', '2012-08-20 14:50:03', null), ('8', 'dao.hb.OAttachment', '5', 'bind', '3', null, null, null, '\\8.js', null, '1', '2012-08-22 10:20:13', null), ('9', 'dao.hb.OLocation', '340', '中科6层平面图', '2', null, null, null, '_[1]1_2013_03_11_5_e1.jpg', null, '1', null, null), ('10', 'dao.hb.SCljz', '9', 'bind', '3', null, null, null, '\\10.js', null, '1', '2013-03-11 16:39:37', null), ('11', 'dao.hb.OAttachment', '9', 'bind', '3', null, null, null, '\\11.js', null, '1', '2013-03-11 16:43:54', null), ('12', 'dao.hb.SClpd', '18', null, null, null, null, null, '_[1]1_2013_08_09_2_th.jpeg', null, null, null, null), ('13', 'dao.hb.SClpd', '18', null, null, null, null, null, '_[1]1_2013_08_09_4_20602_185901080721_2.jpg', null, null, null, null), ('14', 'dao.hb.SClpd', '2', '', null, null, null, null, '_[1]1_2013_12_12_3_pic.jpg', null, null, null, null), ('15', 'dao.hb.UGrant', '2', null, null, null, null, null, '_[1]1_2013_12_12_11_ss1.png', null, null, null, null), ('16', 'dao.hb.OLocation', '1', null, null, null, null, null, null, null, null, null, null), ('17', 'dao.hb.PProject', '1', null, null, null, null, null, '_[1]1_2013_12_21_2_1.jpeg', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_device`
-- ----------------------------
DROP TABLE IF EXISTS `o_device`;
CREATE TABLE `o_device` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备序号',
  `mid` int(11) NOT NULL COMMENT '设备类型序号',
  `sid` int(11) NOT NULL COMMENT '地理位置序号',
  `lid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL COMMENT '创建时间',
  `dt_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL COMMENT '启用,禁用',
  `name` varchar(255) DEFAULT NULL COMMENT '设备名称',
  `sno` varchar(255) DEFAULT NULL COMMENT '设备编号',
  `position` varchar(255) DEFAULT NULL COMMENT '机柜编号',
  `direction` varchar(255) DEFAULT NULL COMMENT '所属域/子系统',
  `properties` varchar(4096) DEFAULT NULL,
  `ip_addr` varchar(255) DEFAULT NULL COMMENT 'ip地址',
  `ip_mask` varchar(255) DEFAULT NULL,
  `ip_gateway` varchar(255) DEFAULT NULL,
  `ip_mac` varchar(255) DEFAULT NULL,
  `islinked` int(11) DEFAULT NULL COMMENT '设备是否连通',
  `iconid` varchar(255) DEFAULT NULL COMMENT '复用拓朴图设备图标ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COMMENT='设备表';

-- ----------------------------
--  Records of `o_device`
-- ----------------------------
BEGIN;
INSERT INTO `o_device` VALUES ('1', '5', '1', null, null, '2013-03-19 21:19:23', 'jh\n\n\nertwtetetw<div><br></div><div>lkkssss中文</div>', '0', '设备111', '65777', null, null, null, '127.0.0.100yyy', null, null, null, null, null), ('2', '5', '2', null, null, null, '4层413号房间\n西南方位', '1', '设备248', '5566yy', null, null, null, '127.0.0.1666kkkk', null, null, null, null, null), ('3', '2', '3', null, null, null, '', '1', '设备333', '447766', null, null, null, '127.0.0.1yyy', null, null, null, null, null), ('4', '5', '339', null, null, null, '', '0', '名称111', '编号11', null, null, null, '127.0.0.1', null, null, null, null, null), ('8', '4', '339', null, null, null, '1层506房间\n东北方位', '0', '339-gti-node-8', '339-gti-node-8', null, null, null, '', null, null, null, null, null), ('9', '3', '339', null, null, null, 'iiuklklkl\nbjhjh', '0', '339-gti-node-99yyjj', '339-gti-node-9', null, null, null, '999', null, null, null, null, null), ('11', '3', '339', null, null, null, '4层403号房间\n西南方位', '1', '339-gti-ap-5', '339-gti-ap-511', null, null, null, '', null, null, null, null, null), ('16', '3', '339', null, null, null, '4层413号房间\n西南方位', '1', '339-gti-node-6', '339-gti-node-6', null, null, null, '', null, null, null, null, null), ('17', '3', '339', null, null, null, '4层423号房间\n西南方位', '1', '339-gti-node-7', '339-gti-node-7', null, null, null, null, null, null, null, null, null), ('18', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('25', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('30', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('31', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('32', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('33', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('34', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('35', '6', '44', null, null, null, null, '1', 'Robot111', 'Robot111', null, null, null, null, null, null, null, null, null), ('36', '0', '0', null, '2013-12-17 20:44:40', '2013-12-17 20:44:40', null, null, null, null, null, null, null, null, null, null, null, null, null), ('37', '0', '0', null, '2013-12-17 20:44:54', '2013-12-17 20:44:54', null, null, null, null, null, null, null, null, null, null, null, null, null), ('38', '2', '0', null, '2013-12-17 20:45:24', '2013-12-17 20:45:24', null, null, null, null, null, null, null, null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_device_item`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_item`;
CREATE TABLE `o_device_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备配置信息序号',
  `mid` int(11) NOT NULL COMMENT '设备型号序号',
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '参数名称',
  `oid` varchar(255) DEFAULT NULL COMMENT '设备参数OID',
  `dispalyname` varchar(255) DEFAULT NULL,
  `style` varchar(255) DEFAULT NULL COMMENT '参数类型,文本、下拉框...',
  `style_param` varchar(255) DEFAULT NULL COMMENT '类型补充值,select option',
  `valtype` varchar(20) DEFAULT NULL COMMENT '参数值类型\r\n            1:整形 2:字符串',
  `ordernum` int(11) DEFAULT NULL COMMENT '显示顺序',
  `vaildconditon` varchar(255) DEFAULT NULL COMMENT '参数有效条件',
  `rule` varchar(255) DEFAULT NULL COMMENT '参数转换规则',
  `coefficient` double(10,2) DEFAULT NULL COMMENT '系数',
  `unit` varchar(50) DEFAULT NULL COMMENT '计量单位',
  `span_val` double(10,2) DEFAULT NULL,
  `span_query` int(11) DEFAULT NULL,
  `tm_create` datetime DEFAULT NULL COMMENT '创建时间',
  `tm_modify` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='设备配置信息表';

-- ----------------------------
--  Table structure for `o_device_manage`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_manage`;
CREATE TABLE `o_device_manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
  `mid` int(11) DEFAULT NULL COMMENT '设备型号序号',
  `mode` varchar(255) DEFAULT NULL COMMENT '方式',
  `URI` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `mnu_ord` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `o_device_manage`
-- ----------------------------
BEGIN;
INSERT INTO `o_device_manage` VALUES ('1', '6', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_device_type`
-- ----------------------------
DROP TABLE IF EXISTS `o_device_type`;
CREATE TABLE `o_device_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '设备属性',
  `stype` varchar(255) DEFAULT NULL COMMENT '设备型号',
  `smode` varchar(255) DEFAULT NULL COMMENT '设备状态采集方式,与本地系统配置对应(udp/snmp/trap)',
  `attr_label` varchar(255) DEFAULT NULL,
  `attr_tip` varchar(255) DEFAULT NULL,
  `handle` varchar(255) DEFAULT NULL,
  `handle_para` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='设备类型及型号基表';

-- ----------------------------
--  Records of `o_device_type`
-- ----------------------------
BEGIN;
INSERT INTO `o_device_type` VALUES ('1', null, null, null, null, '0', 'Camera', '007', 'CAM_Robot', null, null, null, null), ('2', null, null, null, null, '1', 'GTI_AP', '005', 'Socket', null, null, null, null), ('3', null, null, null, null, '1', 'GTI_Node', '001', '', null, null, null, null), ('4', null, null, null, null, '1', 'GTI_AP_Robot', '001', 'GTI_Robot', null, null, null, null), ('5', null, null, null, null, '1', 'CAM_Robot', '003', 'CAM_Robot', null, null, null, null), ('6', null, null, null, null, '1', 'Robot', '005', 'Robot', '类型6: ${ATTR_bind}\\n\\ndt: ${dt} \\ntmpr: ${tmpr} \\nhumi: ${humi}', null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `o_location`
-- ----------------------------
DROP TABLE IF EXISTS `o_location`;
CREATE TABLE `o_location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `longitude` double DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `bw` double DEFAULT NULL,
  `bn` double DEFAULT NULL,
  `be` double DEFAULT NULL,
  `bs` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=341 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `o_location`
-- ----------------------------
BEGIN;
INSERT INTO `o_location` VALUES ('339', null, null, null, null, '0', '梅兰芳大剧院', null, null, '116.355118', '39.933071', '116.3584443', '39.930694'), ('340', null, null, null, null, '1', '北京中科科仪', null, null, '116.321638', '39.992151', '116.3233288', '39.991219');
COMMIT;

-- ----------------------------
--  Table structure for `p_component`
-- ----------------------------
DROP TABLE IF EXISTS `p_component`;
CREATE TABLE `p_component` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `summery` text,
  `status` varchar(255) DEFAULT NULL,
  `dt_start` datetime DEFAULT NULL,
  `dt_end` datetime DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `p_project`
-- ----------------------------
DROP TABLE IF EXISTS `p_project`;
CREATE TABLE `p_project` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `keyname` varchar(255) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `summery` text,
  `dt_due` datetime DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `p_project`
-- ----------------------------
BEGIN;
INSERT INTO `p_project` VALUES ('1', '1', null, '113', 'PJ13', '合同', '需求调研', '', null, '2013-12-25 00:00:00', '2013-12-02 00:00:00', '2013-12-19 20:54:21'), ('2', '1', '9', '项目', 'PRJ23', '外派', '部署', '', null, null, '2013-12-19 10:20:16', '2013-12-19 20:50:27');
COMMIT;

-- ----------------------------
--  Table structure for `p_task`
-- ----------------------------
DROP TABLE IF EXISTS `p_task`;
CREATE TABLE `p_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `tid` int(11) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `stype` varchar(255) DEFAULT NULL,
  `priority` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `summery` text,
  `resolved` varchar(255) DEFAULT NULL,
  `dt_due` datetime DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `dt_resolved` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `p_task`
-- ----------------------------
BEGIN;
INSERT INTO `p_task` VALUES ('1', '1', null, '899', null, '9', null, '测试bug', 'Critical', null, 'wsqss', null, null, '2013-12-18 12:58:19', '2013-12-18 12:58:19', null), ('2', '1', '1', '8', null, '1', '任务2', null, null, null, null, null, null, '2013-12-18 13:30:26', '2013-12-18 13:30:26', null), ('3', '1', null, null, null, '8', null, '测试bug', null, null, null, null, null, '2013-12-18 13:44:04', '2013-12-18 13:44:04', null), ('4', '1', null, null, '1', '1', '', '测试bug', null, null, 'kjkjfd@陈胜 jafdsfdsfdajf@张星炜 kjfaaff', null, null, '2013-12-18 13:44:43', '2013-12-18 13:44:43', null), ('5', '1', '1', null, null, '6', '任务5', null, null, null, null, null, null, '2013-12-18 19:55:18', '2013-12-18 19:55:18', null), ('6', '1', null, null, '2', '8', '建议111', '新功能', 'Critical', '处理中', '@张星炜 @陈胜 ', '测试未完成', null, '2013-12-19 10:18:20', '2013-12-19 10:18:20', null), ('7', '1', '2', '9', null, '8', 'task7', null, 'Critical', '已解决', null, '测试未完成', null, '2013-12-19 10:22:12', '2013-12-19 10:22:12', null), ('8', '1', null, '78', null, '9', 'su', null, null, null, null, null, '2013-12-24 00:00:00', '2013-12-19 12:06:27', '2013-12-19 12:06:27', null), ('9', '1', '1', null, null, '1', 'hhh', '新功能', 'Critical', '处理中', null, '无法修改', null, '2013-12-21 23:26:01', '2013-12-21 23:26:01', null);
COMMIT;

-- ----------------------------
--  Table structure for `r_rel`
-- ----------------------------
DROP TABLE IF EXISTS `r_rel`;
CREATE TABLE `r_rel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `entity1` varchar(255) DEFAULT NULL,
  `id1` int(11) DEFAULT NULL,
  `entity2` varchar(255) DEFAULT NULL,
  `id2` int(11) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `r_rel`
-- ----------------------------
BEGIN;
INSERT INTO `r_rel` VALUES ('4', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '6', '0', null, null), ('6', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '1', '2', null, null), ('7', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '8', '2', null, null), ('8', null, 'dao.hb.PProject', null, 'dao.hb.UUser', '9', '0', null, null), ('9', null, 'dao.hb.PProject', null, 'dao.hb.UUser', '8', '1', null, null), ('10', null, 'dao.hb.PProject', '2', 'dao.hb.UUser', '8', '0', null, null), ('11', null, 'dao.hb.PProject', '2', 'dao.hb.UUser', '9', '1', null, null), ('12', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '718', '3', null, null), ('13', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '717', '4', null, null), ('14', null, 'dao.hb.PProject', '1', 'dao.hb.UUser', '719', '5', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `u_grant`
-- ----------------------------
DROP TABLE IF EXISTS `u_grant`;
CREATE TABLE `u_grant` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `gid` int(10) DEFAULT NULL,
  `uid` int(10) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `pm_menu` varchar(255) DEFAULT NULL,
  `pm_entity` varchar(255) DEFAULT NULL,
  `pm_oper` int(10) DEFAULT NULL,
  `pm_includes` varchar(255) DEFAULT NULL,
  `pm_excludes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `u_grant`
-- ----------------------------
BEGIN;
INSERT INTO `u_grant` VALUES ('1', '1', '1', null, null, null, null, '1', '1', '3', null, null), ('2', '2', null, '2012-10-10 10:17:11', null, null, null, '1', '全部', '3', null, null), ('3', '5', null, '2013-07-06 09:26:32', '2013-07-06 09:26:32', null, null, '8', '', null, null, null), ('4', '5', null, '2013-07-06 09:26:32', '2013-07-06 09:26:32', null, null, '9', null, null, null, null), ('5', '5', null, '2013-07-06 09:26:32', '2013-07-06 09:26:32', null, null, null, 'dao.hb.SClpd', '2', null, null), ('6', '6', null, '2013-07-06 10:15:55', '2013-07-06 10:15:55', null, null, '7', null, null, null, null), ('7', '6', null, '2013-07-06 10:15:55', '2013-07-06 10:15:55', null, null, '8', null, null, null, null), ('8', '6', null, '2013-07-06 10:15:55', '2013-07-06 10:15:55', null, null, '9', null, null, null, null), ('9', '6', null, '2013-07-06 10:15:55', '2013-07-06 10:15:55', null, null, null, 'dao.hb.SCljz', '3', null, null), ('10', '6', null, '2013-07-06 10:15:55', '2013-07-06 10:15:55', null, null, null, 'dao.hb.SClpd', '3', null, null);
COMMIT;

-- ----------------------------
--  Table structure for `u_group`
-- ----------------------------
DROP TABLE IF EXISTS `u_group`;
CREATE TABLE `u_group` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `u_group`
-- ----------------------------
BEGIN;
INSERT INTO `u_group` VALUES ('1', '1', null, null, null, null, 'DEV'), ('2', null, null, null, null, null, 'AGENT'), ('3', null, '2012-10-10 10:15:44', null, null, null, 'RESTAURANT'), ('4', null, '2012-10-10 10:16:19', null, null, null, 'CONSUMER'), ('5', null, '2013-07-06 09:22:28', '2013-07-06 09:22:28', null, null, 'REVIEWER'), ('6', null, '2013-07-06 09:23:35', '2013-07-06 09:23:35', null, null, 'TESTER');
COMMIT;

-- ----------------------------
--  Table structure for `u_org`
-- ----------------------------
DROP TABLE IF EXISTS `u_org`;
CREATE TABLE `u_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `oid` varchar(255) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  `ord` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `u_org`
-- ----------------------------
BEGIN;
INSERT INTO `u_org` VALUES ('67', 'adfe095c-2bc1-4f98-9437-c045e928f699', '0', '总裁办', null, null, null, null, null, '1'), ('68', '9830fffc-fe5e-4f5e-b004-2a775642f0ac', '0', '财务部', null, null, null, null, null, '1'), ('69', 'decb42bf-79db-498b-b258-8344ba6c7368', '0', '综合部', null, null, null, null, null, '1'), ('70', '9e189c5d-b45c-4ce8-8ec9-ec3b95fd19b2', '0', '软件工程部', null, null, null, null, null, '1'), ('71', '172b330a-b4fa-43e4-982e-73c064d303d6', '0', '产品研发部', null, null, null, null, null, '1'), ('72', '5039f5e5-752c-495e-ad73-b811e3777de1', '0', '系统集成部', null, null, null, null, null, '1'), ('73', '7b47e54b-2918-48a0-aefb-d3502bb71396', '0', '客服部', null, null, null, null, null, '1'), ('74', 'e944d9ca-b9d0-4c7e-80e5-22c73ec84a7b', '0', '智能工程部', null, null, null, null, null, '1'), ('75', 'f9bd968e-74f2-47b6-be1e-188406e2b299', '0', '市场部', null, null, null, null, null, '1'), ('76', 'test', '0', '测试部门', null, null, null, null, null, '1'), ('77', '28c007ed-c9b8-4c01-8b4f-00d746f56573', '0', '外部用户组', null, null, null, null, null, '1');
COMMIT;

-- ----------------------------
--  Table structure for `u_user`
-- ----------------------------
DROP TABLE IF EXISTS `u_user`;
CREATE TABLE `u_user` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `gid` int(10) NOT NULL,
  `uid` int(10) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `lang` varchar(255) DEFAULT NULL,
  `ipaddr` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `weibo` varchar(255) DEFAULT NULL,
  `dpt` varchar(255) DEFAULT NULL,
  `qq` varchar(255) DEFAULT NULL,
  `valid_email` tinyint(1) DEFAULT NULL,
  `valid_tel` tinyint(1) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(10) DEFAULT NULL,
  `user_id` varchar(255) NOT NULL,
  `pwd` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `name_pyh` varchar(255) DEFAULT NULL,
  `dt_login` datetime DEFAULT NULL,
  `dt_logout` datetime DEFAULT NULL,
  `online` int(10) DEFAULT NULL,
  `handle` varchar(255) DEFAULT NULL,
  `dt_create` datetime DEFAULT NULL,
  `dt_modify` datetime DEFAULT NULL,
  `dt_sync` datetime DEFAULT NULL,
  `sync_id` int(10) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `oid` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=818 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `u_user`
-- ----------------------------
BEGIN;
INSERT INTO `u_user` VALUES ('1', '1', '1', null, 'zh-CN', '0:0:0:0:0:0:0:1%0', null, null, null, null, null, null, null, null, null, '1', 'sys', '2a394798a5ea52f6f7358eab170d277c', 'sysroot', 'sysroot', '2013-12-31 12:05:35', '2013-12-31 12:05:33', '1', '06630dbf-ed3f-4ef2-8e36-92371ec38448', null, '2013-03-28 06:39:13', null, null, '1\\avatar.jpg', null), ('6', '2', '1', null, 'zh', '0:0:0:0:0:0:0:1%0', null, null, null, null, null, null, null, null, null, '1', 'ag56', 'e3c96ccae6ff52a436c655d31d619172', 'ag5888', 'ag5888', '2013-04-07 20:07:03', '2013-04-07 20:07:29', '0', 'e7429fb4-8237-4773-bd64-2da7dcc217a7', '2012-10-10 16:17:09', '2012-10-12 13:18:08', null, null, '6\\avatar.jpg', null), ('8', '1', '1', null, null, '0:0:0:0:0:0:0:1%0', null, null, null, null, null, null, null, null, 'ddd', '1', 'reviewer_1', '73d6f77a788140561e93e549b5cc68e4', '胖东瓜', 'pdg', '2013-12-22 15:20:15', '2013-12-22 15:28:24', '0', 'b589cf60-4289-45f7-90f6-29b63bb15472', '2013-07-06 09:43:56', '2013-07-06 09:43:56', null, null, null, null), ('9', '6', '1', null, null, '0:0:0:0:0:0:0:1%0', null, null, null, null, null, null, null, null, null, '1', 'tester_1999', '4c006305a359e517d5ef8746a6d7184c', '令狐冲', 'lhc', '2013-07-06 13:22:03', '2013-07-06 13:22:20', '0', '7fbbd9bc-b88f-44fd-967a-50cfa4e9b852', '2013-07-06 10:17:16', '2013-07-06 10:17:16', null, null, null, null), ('717', '6', '1', null, null, null, 'zhangxw@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhangxw', null, '张星炜', 'zxw', null, null, null, null, null, null, null, null, null, '75'), ('718', '6', '1', null, null, null, 'yangzx@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yangzx', null, '杨子萱', 'yzx', null, null, null, null, null, null, null, null, null, '75'), ('719', '6', '1', null, null, null, 'wangjuan@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjuan', null, '王娟', 'wj', null, null, null, null, null, null, null, null, null, '74'), ('720', '6', '1', null, null, null, 'lixin@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lixin', null, '李昕', 'lx', null, null, null, null, null, null, null, null, null, '74'), ('721', '6', '1', null, null, null, 'hanmin@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'hanmin', null, '韩敏', 'hm', null, null, null, null, null, null, null, null, null, '74'), ('722', '6', '1', null, null, null, 'wangjc@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjc', null, '王金成', 'wjc', null, null, null, null, null, null, null, null, null, '74'), ('723', '6', '1', null, null, null, 'wangjuan@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjuan', null, '王娟', 'wj', null, null, null, null, null, null, null, null, null, '74'), ('724', '6', '1', null, null, null, 'lixin@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lixin', null, '李昕', 'lx', null, null, null, null, null, null, null, null, null, '74'), ('725', '6', '1', null, null, null, 'hanmin@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'hanmin', null, '韩敏', 'hm', null, null, null, null, null, null, null, null, null, '74'), ('726', '6', '1', null, null, null, 'wangjc@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjc', null, '王金成', 'wjc', null, null, null, null, null, null, null, null, null, '74'), ('727', '6', '1', null, null, null, 'fangyi@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'fangyi', null, '房毅', 'fy', null, null, null, null, null, null, null, null, null, '73'), ('728', '6', '1', null, null, null, 'fengribing@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'fengribing', null, '丰日兵', 'frb', null, null, null, null, null, null, null, null, null, '73'), ('729', '6', '1', null, null, null, 'xuexb@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xuexb', null, '薛喜斌', 'xxb', null, null, null, null, null, null, null, null, null, '73'), ('730', '6', '1', null, null, null, 'liusong@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liusong', null, '刘嵩', 'ls', null, null, null, null, null, null, null, null, null, '72'), ('731', '6', '1', null, null, null, 'songcw@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'songcw', null, '宋成为', 'scw', null, null, null, null, null, null, null, null, null, '72'), ('732', '6', '1', null, null, null, 'liupeng@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liupeng', null, '刘鹏', 'lp', null, null, null, null, null, null, null, null, null, '72'), ('733', '6', '1', null, null, null, 'changying@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'changying', null, '常颖', 'cy', null, null, null, null, null, null, null, null, null, '72'), ('734', '6', '1', null, null, null, 'zhengchen@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhengchen', null, '郑晨', 'zc', null, null, null, null, null, null, null, null, null, '72'), ('735', '6', '1', null, null, null, 'liuwy@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liuwy', null, '刘位一', 'lwy', null, null, null, null, null, null, null, null, null, '72'), ('736', '6', '1', null, null, null, 'zhangbo@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhangbo', null, '张博', 'zb', null, null, null, null, null, null, null, null, null, '72'), ('737', '6', '1', null, null, null, 'lrf@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lrf', null, '梁汝峰', 'lrf', null, null, null, null, null, null, null, null, null, '72'), ('738', '6', '1', null, null, null, 'jianghw@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'jianghw', null, '姜宏伟', 'jhw', null, null, null, null, null, null, null, null, null, '72'), ('739', '6', '1', null, null, null, 'yudq@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yudq', null, '于大千', 'ydq', null, null, null, null, null, null, null, null, null, '72'), ('740', '6', '1', null, null, null, 'guanhm@sinosoftech.com', '13552977330', null, null, null, null, null, null, null, null, 'guanhm', null, '管浩明', 'ghm', null, null, null, null, null, null, null, null, null, '72'), ('741', '6', '1', null, null, null, 'caobz@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'caobz', null, '曹宝璋', 'cbz', null, null, null, null, null, null, null, null, null, '72'), ('742', '6', '1', null, null, null, 'fengdq@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'fengdq', null, '冯丹青', 'fdq', null, null, null, null, null, null, null, null, null, '72'), ('743', '6', '1', null, null, null, 'zhangsw@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhangsw', null, '张书玮', 'zsw', null, null, null, null, null, null, null, null, null, '72'), ('744', '6', '1', null, null, null, 'xuxiang@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xuxiang', null, '许翔', 'xx', null, null, null, null, null, null, null, null, null, '72'), ('745', '6', '1', null, null, null, 'wangwei@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangwei', null, '王伟', 'ww', null, null, null, null, null, null, null, null, null, '72'), ('746', '6', '1', null, null, null, 'zhaona@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhaona', null, '赵娜', 'zn', null, null, null, null, null, null, null, null, null, '72'), ('747', '6', '1', null, null, null, 'liuzq@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liuzq', null, '刘仲乔', 'lzq', null, null, null, null, null, null, null, null, null, '72'), ('748', '6', '1', null, null, null, 'licy@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'licy', null, '李澄宇', 'lcy', null, null, null, null, null, null, null, null, null, '72'), ('749', '6', '1', null, null, null, 'renhong@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'renhong', null, '任宏', 'rh', null, null, null, null, null, null, null, null, null, '72'), ('750', '6', '1', null, null, null, 'xple@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xple', null, '乐筱萍', 'lxp', null, null, null, null, null, null, null, null, null, '72'), ('751', '6', '1', null, null, null, 'cuimeng@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'cuimeng', null, '崔萌', 'cm', null, null, null, null, null, null, null, null, null, '72'), ('752', '6', '1', null, null, null, 'chenyp@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chenyp', null, '陈钰平', 'cyp', null, null, null, null, null, null, null, null, null, '72'), ('753', '6', '1', null, null, null, 'peiff@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'peiff', null, '裴菲菲', 'pff', null, null, null, null, null, null, null, null, null, '72'), ('754', '6', '1', null, null, null, 'yinyue@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yinyue', null, '殷越', 'yy', null, null, null, null, null, null, null, null, null, '72'), ('755', '6', '1', null, null, null, 'liugw@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liugw', null, '刘钢伟', 'lgw', null, null, null, null, null, null, null, null, null, '72'), ('756', '6', '1', null, null, null, 'xuejb@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xuejb', null, '薛建彬', 'xjb', null, null, null, null, null, null, null, null, null, '72'), ('757', '6', '1', null, null, null, 'zhouzq@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhouzq', null, '周志强', 'zzq', null, null, null, null, null, null, null, null, null, '72'), ('758', '6', '1', null, null, null, 'Liucx@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'Liucx', null, '刘春晓', 'lcx', null, null, null, null, null, null, null, null, null, '72'), ('759', '6', '1', null, null, null, 'tianyong@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'tianyong', null, '田勇', 'ty', null, null, null, null, null, null, null, null, null, '72'), ('760', '6', '1', null, null, null, 'zhouxt@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhouxt', null, '周鑫婷', 'zxt', null, null, null, null, null, null, null, null, null, '72'), ('761', '6', '1', null, null, null, 'sunmy@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'sunmy', null, '孙明月', 'smy', null, null, null, null, null, null, null, null, null, '72'), ('762', '6', '1', null, null, null, 'qiaolf@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'qiaolf', null, '乔莉芬', 'qlf', null, null, null, null, null, null, null, null, null, '72'), ('763', '6', '1', null, null, null, 'sujie@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'sujie', null, '苏洁', 'sj', null, null, null, null, null, null, null, null, null, '72'), ('764', '6', '1', null, null, null, 'wanglimin@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wanglimin', null, '王利民', 'wlm', null, null, null, null, null, null, null, null, null, '72'), ('765', '6', '1', null, null, null, 'haoyh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'haoyh', null, '郝永红', 'hyh', null, null, null, null, null, null, null, null, null, '72'), ('766', '6', '1', null, null, null, 'chengtao@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chengtao', null, '程韬', 'ct', null, null, null, null, null, null, null, null, null, '72'), ('767', '6', '1', null, null, null, 'mengqh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'mengqh', null, '孟庆晖', 'mqh', null, null, null, null, null, null, null, null, null, '72'), ('768', '6', '1', null, null, null, 'baijie@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'baijie', null, '白洁', 'bj', null, null, null, null, null, null, null, null, null, '72'), ('769', '6', '1', null, null, null, 'liuxi@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liuxi', null, '刘溪', 'lx', null, null, null, null, null, null, null, null, null, '72'), ('770', '6', '1', null, null, null, 'zhaowb@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhaowb', null, '赵兀斌', 'zwb', null, null, null, null, null, null, null, null, null, '72'), ('771', '6', '1', null, null, null, 'zhaohj@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhaohj', null, '赵焕军', 'zhj', null, null, null, null, null, null, null, null, null, '71'), ('772', '6', '1', null, null, null, 'wangjia@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjia', null, '王嘉', 'wj', null, null, null, null, null, null, null, null, null, '71'), ('773', '6', '1', null, null, null, 'taoj@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'taoj', null, '陶洁', 'tj', null, null, null, null, null, null, null, null, null, '71'), ('774', '6', '1', null, null, null, 'hegx@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'hegx', null, '何更喜', 'hgx', null, null, null, null, null, null, null, null, null, '71'), ('775', '6', '1', null, null, null, 'chenxz@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chenxz', null, '陈宪章', 'cxz', null, null, null, null, null, null, null, null, null, '71'), ('776', '6', '1', null, null, null, 'jiangbuyun@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'jiangbuyun', null, '蒋步云', 'jby', null, null, null, null, null, null, null, null, null, '71'), ('777', '6', '1', null, null, null, 'yangwen@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yangwen', null, '杨文', 'yw', null, null, null, null, null, null, null, null, null, '71'), ('778', '6', '1', null, null, null, 'qiaozm@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'qiaozm', null, '乔照民', 'qzm', null, null, null, null, null, null, null, null, null, '71'), ('779', '6', '1', null, null, null, 'chenxzh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chenxzh', null, '陈宪章', 'cxz', null, null, null, null, null, null, null, null, null, '71'), ('780', '6', '1', null, null, null, 'xuty@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xuty', null, '徐天元', 'xty', null, null, null, null, null, null, null, null, null, '71'), ('781', '6', '1', null, null, null, 'yangym@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yangym', null, '杨雅敏', 'yym', null, null, null, null, null, null, null, null, null, '71'), ('782', '6', '1', null, null, null, 'sunfu@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'sunfu', null, '孙芙', 'sf', null, null, null, null, null, null, null, null, null, '67'), ('783', '6', '1', null, null, null, 'lianggeng@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lianggeng', null, '梁赓', 'lg', null, null, null, null, null, null, null, null, null, '67'), ('784', '6', '1', null, null, null, 'zhuqm@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhuqm', null, '朱清明', 'zqm', null, null, null, null, null, null, null, null, null, '67'), ('785', '6', '1', null, null, null, 'licx@sinosoftech.com', '13311191085', null, null, null, null, null, null, null, null, 'licx', null, '李春晓', 'lcx', null, null, null, null, null, null, null, null, null, '67'), ('786', '6', '1', null, null, null, 'yangxp@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'yangxp', null, '杨学平', 'yxp', null, null, null, null, null, null, null, null, null, '67'), ('787', '6', '1', null, null, null, 'zhuwl@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhuwl', null, '朱文龙', 'zwl', null, null, null, null, null, null, null, null, null, '67'), ('788', '6', '1', null, null, null, 'zhaolx@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'zhaolx', null, '赵林选', 'zlx', null, null, null, null, null, null, null, null, null, '68'), ('789', '6', '1', null, null, null, 'kongfr@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'kongfr', null, '孔繁荣', 'kfr', null, null, null, null, null, null, null, null, null, '68'), ('790', '6', '1', null, null, null, 'liyz@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liyz', null, '李银哲', 'lyz', null, null, null, null, null, null, null, null, null, '68'), ('791', '6', '1', null, null, null, 'changshuang@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'changshuang', null, '常爽', 'cs', null, null, null, null, null, null, null, null, null, '68'), ('792', '6', '1', null, null, null, 'weiyang@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'weiyang', null, '尉洋', 'wy', null, null, null, null, null, null, null, null, null, '68'), ('793', '6', '1', null, null, null, 'wangpei@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangpei', null, '王裴', 'wp', null, null, null, null, null, null, null, null, null, '69'), ('794', '6', '1', null, null, null, 'qiwb@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'qiwb', null, '祁文博', 'qwb', null, null, null, null, null, null, null, null, null, '69'), ('795', '6', '1', null, null, null, 'dongnan@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'dongnan', null, '董楠', 'dn', null, null, null, null, null, null, null, null, null, '69'), ('796', '6', '1', null, null, null, 'cuizhe@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'cuizhe', null, '崔哲（综合部）', 'cz（zhb）', null, null, null, null, null, null, null, null, null, '69'), ('797', '6', '1', null, null, null, 'kongcq@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'kongcq', null, '孔垂强', 'kcq', null, null, null, null, null, null, null, null, null, '69'), ('798', '6', '1', null, null, null, 'liujian@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liujian', null, '刘健', 'lj', null, null, null, null, null, null, null, null, null, '70'), ('799', '6', '1', null, null, null, '', '', null, null, null, null, null, null, null, null, '40f98732-9eb4-482b-ac54-2b98fd54dda4', null, '彭现陈共享', 'pxcgx', null, null, null, null, null, null, null, null, null, '70'), ('800', '6', '1', null, null, null, 'chensheng@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chensheng', null, '陈胜', 'cs', null, null, null, null, null, null, null, null, null, '70'), ('801', '6', '1', null, null, null, 'wangjh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangjh', null, '王继华', 'wjh', null, null, null, null, null, null, null, null, null, '70'), ('802', '6', '1', null, null, null, 'xurui@sinosoftech.com', '13910000711', null, null, null, null, null, null, null, null, 'xurui', null, '徐睿', 'xr', null, null, null, null, null, null, null, null, null, '70'), ('803', '6', '1', null, null, null, 'wangtao@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangtao', null, '汪涛', 'wt', null, null, null, null, null, null, null, null, null, '70'), ('804', '6', '1', null, null, null, 'xuyl@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'xuyl', null, '徐雅莉', 'xyl', null, null, null, null, null, null, null, null, null, '70'), ('805', '6', '1', null, null, null, 'renguodong@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'renguodong', null, '任国栋', 'rgd', null, null, null, null, null, null, null, null, null, '70'), ('806', '6', '1', null, null, null, 'lvxl@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lvxl', null, '吕新亮', 'lxl', null, null, null, null, null, null, null, null, null, '70'), ('807', '6', '1', null, null, null, 'chenlh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chenlh', null, '陈林华', 'clh', null, null, null, null, null, null, null, null, null, '70'), ('808', '6', '1', null, null, null, 'konglm@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'konglm', null, '孔路明', 'klm', null, null, null, null, null, null, null, null, null, '70'), ('809', '6', '1', null, null, null, 'chengxj@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chengxj', null, '程小进', 'cxj', null, null, null, null, null, null, null, null, null, '70'), ('810', '6', '1', null, null, null, 'liaosp@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'liaosp', null, '廖素萍', 'lsp', null, null, null, null, null, null, null, null, null, '70'), ('811', '6', '1', null, null, null, 'fucj@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'fucj', null, '付春娟', 'fcj', null, null, null, null, null, null, null, null, null, '70'), ('812', '6', '1', null, null, null, 'chentao@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'chentao', null, '陈涛', 'ct', null, null, null, null, null, null, null, null, null, '70'), ('813', '6', '1', null, null, null, 'goulm@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'goulm', null, '勾立明', 'glm', null, null, null, null, null, null, null, null, null, '70'), ('814', '6', '1', null, null, null, 'wangdh@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangdh', null, '王东华', 'wdh', null, null, null, null, null, null, null, null, null, '70'), ('815', '6', '1', null, null, null, 'lixl@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'lixl', null, '李新蕾', 'lxl', null, null, null, null, null, null, null, null, null, '70'), ('816', '6', '1', null, null, null, 'pengxc@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'pengxc', null, '彭现陈 ', 'pxc ', null, null, null, null, null, null, null, null, null, '70'), ('817', '6', '1', null, null, null, 'wangchun@sinosoftech.com', '', null, null, null, null, null, null, null, null, 'wangchun', null, '王纯', 'wc', null, null, null, null, null, null, null, null, null, '70');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
